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.
Expert Cube Development with SSAS Multidimensional Models
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
Free Chapter
Designing the Data Warehouse for Analysis Services
Building Basic Dimensions and Cubes
Designing More Complex Dimensions
Measures and Measure Groups
Handling Transactional-Level Data
Adding Calculations to the Cube
Adding Currency Conversion
Query Performance Tuning
Securing the Cube
Going in Production
Monitoring Cube Performance and Usage
DAX Query Support
Index
Customer Reviews