Chapter 11. Monitoring Cube Performance and Usage
We need to be able to monitor activity on Analysis Services if we're going to be able to detect possible performance issues, to provide good service levels and to optimize individual queries or processing operations. In order to learn how to do this, first of all we need to know how Analysis Services interacts with the operating system. Resources consumed by Analysis Services are controlled by the operating system and we need to understand these relationships. After an introduction to the tools and performance counters provided by the operating system, we will look at the Analysis Services Memory Manager and how it can be configured. In the last part of this chapter we will examine how to monitor specific operations in Analysis Services like processing and querying.
