Whitepaper : Monitoring Analysis Services Performance

Imagine you’re 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’re like, “No problem it’s just SQL Server right?” 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? In this whitepaper, we will open the black box that is Analysis Services and highlight 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.

Presenter: Stan Geiger
Share This:  Facebook Twitter LinkedIn

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.

Register to read the full whitepaper.



Register for Free Whitepaper

Register For a Free Whitepaper

*
*
*
*
*