How do you monitor the performance of SQL Server Analysis Services (SSAS)?

Imagine that you are a database administrator and your manager comes in and says that the business intelligence team wants to install and configure an instance of SQL Server Analysis Services (SSAS). You are going to be responsible for monitoring the availability and performance of the instance as well as making recommendations for performance improvements. So you are like, “No problem it is just SQL Server, correct?” All of the “tricks of the trade” for SQL Server you have learned over the years will work right? Then you do some research and find out that Analysis Services is not your mother’s SQL Server. So now what are you going to do?

Read the 16-page whitepaper “Monitoring Analysis Services Performance to learn about the black box that is Analysis Services and the key areas of performance monitoring. We will discuss the overall architecture of Analysis Services and then the detailed metrics that are key to SSAS performance. It is extremely important to have a good understanding of SSAS works under the hood when doing performance troubleshooting. This whitepaper describes the architecture, query processing, performance metrics, the network, disk input/output (I/O), memory, central processing unit (CPU), MDX (the query language to query a multidimensional cube), and processing.

Click here to download the PDF file.

The presenter, Stan Geiger, has over 25 years experience with databases. Stan has been in various roles such as business intelligence (BI) architect, data architect, and developer. He has designed and built large scale data warehouses and multidimensional cube installations in various industries such as finance, healthcare, energy, and the US Department of Defense (DOD). Currently Product Manager for the business intelligence products at IDERA.

Anonymous