BI Sentry is the complete performance monitoring and optimization solution for SQL Server Analysis Service. Gain unparalleled insight into Analysis Services performance issues, including bottlenecks related to memory and storage systems, aggregation usage, unoptimized queries and query and processing tasks competing for the same resources.
- Performance Dashboard: View real-time and historical SQL Server Analysis Services metrics for full performance insight on a single screen
- Top Commands: The Top Commands view provides details about any live or historical long running and/or high impact statements
- Intelligent Alerting: Tap into rich alerting features to build notifications that are timely and meaningful
- Global Server Status View: Be informed of the health status of all of your servers from a single, easy to view screen. Save time by identifying poorly-performing metrics on each of your servers quickly and efficiently
- Performance Reporting: Pre-formatted reports are available on any metrics BI Sentry collects, from a global level down to individual counters
- SSAS and File Cache Usage: Identify data and log files quickly and see how data flows through your disk system. View SSAS internal cache activity and disk activity, including system file cache usage, hit ratios for all cache lookup types and cache growth/shrinkage.