SSAS

How to use performance analysis in SentryOne software (SQL Sentry) for SQL Server Analysis Services target types.

Articles

 SSAS Overview for SQL Sentry
Overview of SSAS performance analysis with SQL Sentry.
SSAS Performance Metrics
This article covers the various SSAS performance metrics displayed by the Performance Analysis Dashboard and Performance Analysis Overview.
 SSAS Top Commands
The Top Command tab shows Analysis Services query level collection and any MDX, DMX, or XMLA commands that have run longer than one second.
 SSAS Usage Totals
The SSAS Usage Totals tab provides information that can be used to determine what actions to take based on activity levels.
 Performance Analysis Disk Activity
Applies to: SQL Server, SSAS*, VMware*, and Windows* targets. Introduction *The Disk Activity and Disk Space tabs are focused on database files. For Windows it applies to VMware and Hyper-V hosts for vDisks and VHDX files, respectiv...
 Performance Analysis Disk Space
Applies to: SQL Server, SSAS*, VMware*, and Windows* targets. Introduction *The Disk Activity and Disk Space tabs are focused on database files. For Windows targets it applies to VMware and Hyper-V hosts for vDisks and VHDX files, r...
 Performance Analysis Top SQL
Applies to: SQL Server, SSAS, and Azure SQL Database target types. See the Monitor Top SQL article for an example of the Top SQL feature in a browser. Introduction The Top SQL tab lists all T-SQL batches, stored procedures (RPCs...
 Performance Analysis Processes
Applies to : Windows, SQL Server, and SSAS targets when the target has Windows (meaning targets on Linux, AWS RDS, and Azure Managed Instance, for example, will not have this tab). It's only available for SQL Server when using the advanced sec...