Book Image

Expert Cube Development with SSAS Multidimensional Models

Book Image

Expert Cube Development with SSAS Multidimensional Models

Overview of this book

Table of Contents (19 chapters)
Expert Cube Development with SSAS Multidimensional Models
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

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 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 such as processing and querying.