SQLBits 2012

Memory Management for Analysis Services with SQL Sentry

Learn how to monitor Analysis Services with SQL Sentry Performance Advisor. Get tips on best practices, monitoring counters and options plus improve your understanding of how Analysis Services uses memory and where it differs from SQL Server.
SQL Server Analysis Services has a reputation as a bit of a “black box”.  While there is some degree of truth to that, as there is less visibility into what’s going on under the hood in Analysis Services than in SQL Server, there is relevant and actionable data available.  Memory management in particular is often a challenge, in part due to the differences between SQL Server and Analysis Services.

In this session Scott Fallen, SQL Sentry Sales Engineer, will cover topics on how to monitor and tune Analysis Services to get the most out of your memory.  You will learn about counters to watch, best practices, and monitoring options.  We will also investigate how Analysis Services uses memory, and how it differs from SQL Server.

The session will wrap up by looking at making Analysis Services monitoring easier and troubleshooting faster by using SQL Sentry Performance Advisor for Analysis Services.  In this segment of the presentation, Scott will demonstrate the live and historical performance dashboards, query capture and analysis, as well as overall usage information captured by Performance Advisor for Analysis Services.