Tag Archives: sqlcat

Resource Monitoring

Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 41 Conceptually, I consider this chapter similar to chapter 38 (on trace monitoring). This chapter introduces a new infrastructure for monitoring server resources called Dynamic Management Views (DMVs), and here are some … Continue reading

Posted in Analysis Services | Tagged , , | Leave a comment

Using Trace to Monitor and Audit Analysis Services

Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 38 This chapter descriptively provides an overview of SQL Server Profiler, the application which can be used to trace Analysis Services.  The information is useful, but I will be offering a more … Continue reading

Posted in Analysis Services | Tagged , | Leave a comment

Building Scalable Analysis Services Applications

Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 25 This chapter talks about the important leverage feature of SSAS, the ability to either scale-up or scale-out (or both): Scale-up means improving the power of a single machine, perhaps by increasing … Continue reading

Posted in Analysis Services | Tagged , , | Leave a comment