BI Sentry: Industry-Leading SSAS Performance Monitoring

The BI Sentry performance dashboard shows both Windows- and SSAS-specific metrics side by side for a complete view of data platform performance.

As part of the SentryOne platform, BI Sentry gives a complete view of Microsoft SSAS performance so you can identify and address problems that have widespread impact across your data platform.

Learn more about the new, extended support for SSAS Tabular in BI Sentry. 

SSAS Top Commands

See the total impact of your MDX, DAX, or XMLA Commands

The SentryOne BI Sentry Top Commands tab shows SQL Server Analysis Services (SSAS) query-level collection and any MDX, DAX, or XMLA commands that have run longer than one second. All the like queries have been rolled up and grouped together so you can see their total impact. Top Commands is one of many features in BI Sentry that helps you identify and address performance problems with SSAS. Learn more.

Advisory Conditions

Intelligent alerts for SQL Server performance problems

SentryOne Advisory Conditions are a proactive alerting and response system that helps you customize notifications based on parameters that are specific to your environment. By using pre-built or customer Advisory Conditions, you can anticipate and prevent database performance problems. Learn more.

SSAS Performance Metrics

Accelerate SSAS performance with detailed, relevant metrics

The SSAS Performance Metrics displayed by the Performance Analysis Dashboard in SentryOne BI Sentry give you valuable insight into the root cause of performance problems with SQL Server Analysis Services (SSAS). With actionable information, you can save time in troubleshooting SSAS performance. Learn more.

SSAS Usage Totals

Use relevant metrics to troubleshoot SSAS problems

The SentryOne SSAS Usage Totals tab in SentryOne BI Sentry provides information that can be used to determine what responses to take based on activity levels. This information is divided into three different groups:

• Attributes—used to see which attribute combinations are hit the most to determine if creating an aggregation would improve performance
• Aggregations—shows the aggregations that are being used
• Partitions—shows which partitions are being read the most

Event Calendar

Manage SQL Server and Windows Events in a visual calendar

The SentryOne Event Calendar is a capability that combines both historical and future SQL Server and Windows event data in a visual, Outlook-style display. With the Event Calendar, you can identify and fix potential conflicts between multiple events—such as SQL Server jobs or Windows scheduled tasks—competing for the same resources, which can slow database performance. Learn more.

Proven scalability

SQL Sentry has proven scalability far beyond competitors' products, with demonstrated success monitoring 800+ targeted database instances with one monitoring database. Our innovative use of SQL Server technology to scale monitoring to large enterprise workloads was the focus of a Microsoft profile.  The article said that SentryOne "has shattered barriers to data ingestion and monitors its customer databases without impediment" and that SQL Sentry is built with current data management trends in mind.

Predict future storage needs

Hate being surprised by insufficient disk storage space, which could bring your databases to a standstill? Storage Forecasting in SQL Sentry takes the guesswork out of planning storage needs by applying machine learning to forecast daily usage for all storage volumes across servers, helping you proactively manage compute resources. The algorithms analyze workloads, fine-tune disk capacity forecasts, and provide intelligent reporting that can help prevent system downtime.