Monitor SQL Business Intelligence SSAS in Real-time

SQL BI Check - Free Tool

  • Real-time performance monitoring for SQL Server Analysis Services (SSAS)
  • See physical server metrics for CPU, disk, and storage
  • View analysis metrics for SSAS processing, memory, and cache
  • Get up and running in minutes, no agents required

Real-time SQL BI Performance Monitoring

Monitor the performance of physical server activity as well as analysis services to get a better picture of your SQL BI systems. Set the refresh rate to as little as 1 minute and see up to 2 ½ hours of data. The configurable dashboard provides an at-a-glance view of the metrics that are important to you.

Physical Server Metrics

View CPU utilization in terms of percentage as well as query pool and processing pool queue lengths. See storage engine activity and cache performance. The sessions bubble chart displays all active sessions visually by CPU time with bubble size and color distinctions to show the most CPU intensive sessions. Hover over a bubble to see a snapshot of session and utilization details.

Analysis Services Metrics

Monitor SSAS processing by rows read and rows written to see the analysis services load. View memory in SSAS specific shrinkable and non-shrinkable categories to get a precise view of the SSAS memory utilization of the overall system memory. See the SSAS cache activity to see how efficiently the cache memory is being used.

Up and Running in Minutes with No Agents

The small download and easy installation wizard will get you up and running quickly. No agents are installed on the server as all metrics are obtained through SQL or WMI.

Integrate with SSMS

Designed to launch directly within SQL Server Management Studio (SQL 2012 and above) for optimal usability and efficient workflow.


IDERA Community

Check out the latest blog posts for product tips & tricks from other users.

Join the Discussion