BI Sentry

Articles

 BI Sentry Overview
BI Sentry allows you to continuously monitor and troubleshoot SQL Server Analysis Services (SSAS) issues in a Multidimensional or Tabular mode. SSAS is a storage engine, executable as msmdsrv.exe., and the two primary types of activities that occur in SSAS are querying and processing.
BI Sentry Performance Metrics
This article covers the various performance metrics displayed by the Performance Analysis Dashboard and Performance Analysis Overview, and how to interpret different metric values and combinations of values across different metrics for BI Sentry.
 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 Sentry, BI Sentry*, V Sentry*, and Win Sentry* *The Disk Activity and Disk Space tabs are focused on database files. For Win Sentry it applies to VMware and Hyper-V hosts for vDisks and VHDX files, respectively. The tabs ...
 Performance Analysis Disk Space
Applies to: SQL Sentry, BI Sentry*, V Sentry*, and Win Sentry* *The Disk Activity and Disk Space tabs are focused on database files. For Win Sentry it applies to VMware and Hyper-V hosts for vDisks and VHDX files, respectively. The tabs ...
 Performance Analysis Top SQL
Applies to: SQL Sentry, BI Sentry, and DB Sentry The Top SQL tab lists all T-SQL batches, stored procedures (RPCs), and statement events collected for the current date range that exceeded the Minimum Duration specified in the Settings&nbs...
 Performance Analysis Processes
Applies to : Win Sentry, SQL Sentry, and BI Sentry 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 Sentry when using the advanced sec...