SSAS

Overview of SSAS performance analysis with SQL Sentry.

This article covers the various SSAS performance metrics displayed by the Performance Analysis Dashboard and Performance Analysis Overview.

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...

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, respectivel...

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...

The Top Command tab shows Analysis Services query level collection and any MDX, DMX, or XMLA commands that have run longer than one second.

The SSAS Usage Totals tab provides information that can be used to determine what actions to take based on activity levels.

Applies to: SQL Server, SSAS, Azure SQL Database, and AWS RDS target types. See the SQL Sentry Portal Top SQL article for an example of the Top SQL feature in a browser. Introduction Top SQL tab The Top SQL tab lists all ...

Applies to: SQL Server, SSAS and AWS RDS targets. As of version 2020.8.31, the table and index data collection is enabled by default during installation. In older versions of SQL Sentry, this feature is disabled by default.  It ...

Applies to: SQL Server and SSAS targets. Access the SQL Sentry AlwaysOn Management page by right-clicking the All Targets node in the Navigator  pane and selecting Open > AlwaysOn Management . Open AlwaysOn M...

Applies to: SQL Server and SSAS targets. The Query Plans tab lists all plans collected for Top SQL completed queries for the specified date range, and provides a detailed chronology of all completed query plan changes. Use Query Plans to lo...

Applies to : The Blocking tab is available for SQL Server, Azure SQL Database, and AWS RDS targets. See the SQL Sentry Portal Blocking article for an example of the Blocking feature in a browser. Overview The Blocking SQL...

Applies to :  The Deadlocks  tab is available for SQL Server, SSAS, Azure SQL Database, and AWS RDS targets. See the SQL Sentry Portal Deadlocks article for an example of the Deadlocks feature in a browser. Overview ...

QuickTrace™ A QuickTrace   is a comprehensive snapshot of activity created by combining process-level data and trace events collected during a brief sample period. Various metrics such as CPU, I/O, recompiles, cache misses, cur...