• Comprehensive monitoring of SSAS, SSRS, and SSIS health
  • See detailed SSAS performance metrics, query activity, and sessions
  • Identify issues with object utilization in both Cube and Tabular models
  • Monitor both user and report activity in SSRS
  • View SSIS package execution details and history
Comprehensive Monitoring of the SQL Server BI Stack

Monitor the health and availability of your entire SQL Server BI environment including SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS). Ensure uptime and identify issues quickly.

Detailed SSAS Performance Metrics

Monitor a wealth of SSAS performance and processing metrics, query activity, cache, sessions, object utilization, and user activity – everything you need and more to keep your analysis services running at peak efficiency.

Tune Object Utilization for Cube and Tabular Models

See the performance of your analysis models as well as your analysis servers. Monitor formula and storage engine cache, memory utilization, and row activity for objects to help you tune both cube and tabular models.

Monitor Reporting Services and Integration Packages

View SSRS performance counters and report execution activity to monitor how long it takes for reports to run, which ones didn’t run, and the impact on server resources. View by user, by session, and by processing time. See SSIS activity to monitor integration package status, execution duration, and if there were errors.

Configurable Alerts

Set alerts and email notifications with configurable threshold levels to keep you informed of only the relevant information.

Web-based Dashboard

Log in from anywhere and quickly check the status of monitored SQL BI server instances. The customizable web dashboard provides at-a-glance status of top issues and alerts with easy drill down capabilities so you can identify and diagnose issues quickly.

Performance Monitoring

SQL Server Analysis Services Monitoring

Get comprehensive monitoring of SQL Server Analysis Services and the servers they reside on. Server metrics include disk, network, cache, CPU, and memory. SSAS performance metrics include processing, query activity, memory, cache, sessions, object utilization, and user activity. Both Multidimensional (MOLAP, Cubes) and Tabular models.

SQL Server Reporting Services Monitoring

Monitor SQL Server Reporting Services and the servers they reside on including OS counters, SSRS Report Server counters, SSRS Web Server counters, and SSRS Windows Service counters. Monitor report execution metrics and track status, view processing time, and see report activity by user.

SQL Server Integration Services Monitoring

Monitor SQL Server Integration Services and the server they reside on including OS counters and performance counters. View SSIS package execution activity including drill down at the task level to track status and view error details.

Alerts and Notifications

Configure critical and warning threshold alerts for over 100 BI service metrics. View color-coded indicators on the dashboard, and receive email notifications to stay on top of potential performance problems.

Enterprise Manangement

Agentless Monitoring

SQL BI Manager does not install anything on your production BI servers. This simplifies installation and keeps the overhead on the monitored servers low. No need to install anything on your SQL Server

Web-based Dashboard

Log in from anywhere and quickly check the status of monitored SQL BI server instances. The customizable web dashboard provides at-a-glance status of top issues and alerts with easy drill down capabilities so you can identify and diagnose issues quickly.

Collaborate and Share

Export data from each view to send to management or share and collaborate with team members.

Secure

Easily give and restrict access to the applications based on a user’s role in the organization with role-based security.

System Requirements

Management Console and Service
  • Windows 7 SP1+
  • Windows 8+
  • Windows 10
  • Windows Server 2008 SP1
  • Windows Server 2008 R2
  • Windows Server 2012
  • Windows Server 2012 R2
  • Windows Server 2016
SQL Server Repository
  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
Monitored SQL Servers
  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2017
Cloud
  • SQL BI Manager runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports Microsoft SQL Server instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2).
Browser Support
  • Internet Explorer 10+
  • Microsoft Edge
  • Chrome
  • Firefox

Version History

Version 2.2
  • Alerting: Set alert thresholds based on relevant metric precision
  • Query monitoring: Collect queries constantly and save query history
  • SSRS monitoring: Register SSRS instances for scale-out deployment
  • User management: Limit access to managed instances based on product user login
  • Bug fixes
Version 2.1
  • Drill down into SSIS packages to identify performance issues and package failures at the task level
  • Support for SQL Server 2016

Version 2.0

  • Dashboard, charting, and UI enhancements.
  • Support in SSAS for both Multidimensional (MOLAP, Cubes) and Tabular Models.
  • Over 20 additional metrics for SSAS monitoring.
  • More in depth SSRS monitoring of reports, subscriptions, and parameters.
  • Monitoring of SSIS package execution and historical performance.
  • Additional enhancements and bug fixes
Version 1.5

Reporting and alerting enhancements including:

  • Reporting on user activity for SSAS, SSRS
  • Alerting and reporting improvements

New dashboard widgets
Additional Enhancements and bug fixes

Version 1.1

Additional data viewing and handling capabilities including:

  • Dashboard – View active sessions for top 10 SSAS instances, view running jobs for top 10 SSIS instances, view active sessions for top 10 SSRS instances.
  • SSRS Performance – Show export data, availability over time, and month and year projections of the data.
  • Administration – Import data, modify monitoring settings, and copy alert thresholds from one instance to another.
null
SQL BI Manager Datasheet
Everything you need to know, all in one downloadable PDF.
DOWNLOAD THE DATASHEET
null
View a Democast
Sign up for the next Live Demo!
REGISTER FOR A DEMOCAST

SQL Business Intelligence Manager Product Tour

Monitor performance of SQL Server BI systems : SQL Business Intelligence (BI) Manager provides comprehensive and agentless monitoring of the servers and services for SQL Server Analysis Services (SSAS), Reporting Services (SSRS), and Integration Services (SSIS). Monitor the health and availability of your entire SQL Server BI environment with a dashboard that displays an alert status and enables you to drill down to find details relating to performance and availability issues.

Configure alerts for BI services : The Alerts view displays all of the current alerts for the monitored BI services along with the historical alerts. Email notifications alert you when services are performing poorly through the configurable alerts functionality. Set your thresholds to trigger the alerts for a variety of BI components such as report generation performance and memory and CPU usage of a service.

View SSRS report history : The SSRS report history shows all reports executed with status, type, executing user, and any report parameters. View SSRS performance counters and report execution activity to monitor how long it takes reports to run, which ones did not run, and the impact on server resources. View by user, session, and processing time.

View monitored SSAS services : Monitor SSAS performance and processing metrics, query activity, cache, sessions, object utilization, and user activity. SQL BI Manager displays the list of monitored service instances for each service and general information about the service instance. Performance information pertaining to a variety of metrics is accessible by selecting a specific service instance.

Review SSIS execution history : The SSIS execution history allows you to search for a particular package execution and then drill down into the steps executed and see performance statistics and status. Upon selecting a step, you can view any warning or error messages associated with that step. View SSIS activity to monitor integration package status, execution duration, and any error occurrences.

    Overview
    • Comprehensive monitoring of SSAS, SSRS, and SSIS health
    • See detailed SSAS performance metrics, query activity, and sessions
    • Identify issues with object utilization in both Cube and Tabular models
    • Monitor both user and report activity in SSRS
    • View SSIS package execution details and history
    Comprehensive Monitoring of the SQL Server BI Stack

    Monitor the health and availability of your entire SQL Server BI environment including SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS). Ensure uptime and identify issues quickly.

    Detailed SSAS Performance Metrics

    Monitor a wealth of SSAS performance and processing metrics, query activity, cache, sessions, object utilization, and user activity – everything you need and more to keep your analysis services running at peak efficiency.

    Tune Object Utilization for Cube and Tabular Models

    See the performance of your analysis models as well as your analysis servers. Monitor formula and storage engine cache, memory utilization, and row activity for objects to help you tune both cube and tabular models.

    Monitor Reporting Services and Integration Packages

    View SSRS performance counters and report execution activity to monitor how long it takes for reports to run, which ones didn’t run, and the impact on server resources. View by user, by session, and by processing time. See SSIS activity to monitor integration package status, execution duration, and if there were errors.

    Configurable Alerts

    Set alerts and email notifications with configurable threshold levels to keep you informed of only the relevant information.

    Web-based Dashboard

    Log in from anywhere and quickly check the status of monitored SQL BI server instances. The customizable web dashboard provides at-a-glance status of top issues and alerts with easy drill down capabilities so you can identify and diagnose issues quickly.

    Details

    Performance Monitoring

    SQL Server Analysis Services Monitoring

    Get comprehensive monitoring of SQL Server Analysis Services and the servers they reside on. Server metrics include disk, network, cache, CPU, and memory. SSAS performance metrics include processing, query activity, memory, cache, sessions, object utilization, and user activity. Both Multidimensional (MOLAP, Cubes) and Tabular models.

    SQL Server Reporting Services Monitoring

    Monitor SQL Server Reporting Services and the servers they reside on including OS counters, SSRS Report Server counters, SSRS Web Server counters, and SSRS Windows Service counters. Monitor report execution metrics and track status, view processing time, and see report activity by user.

    SQL Server Integration Services Monitoring

    Monitor SQL Server Integration Services and the server they reside on including OS counters and performance counters. View SSIS package execution activity including drill down at the task level to track status and view error details.

    Alerts and Notifications

    Configure critical and warning threshold alerts for over 100 BI service metrics. View color-coded indicators on the dashboard, and receive email notifications to stay on top of potential performance problems.

    Enterprise Manangement

    Agentless Monitoring

    SQL BI Manager does not install anything on your production BI servers. This simplifies installation and keeps the overhead on the monitored servers low. No need to install anything on your SQL Server

    Web-based Dashboard

    Log in from anywhere and quickly check the status of monitored SQL BI server instances. The customizable web dashboard provides at-a-glance status of top issues and alerts with easy drill down capabilities so you can identify and diagnose issues quickly.

    Collaborate and Share

    Export data from each view to send to management or share and collaborate with team members.

    Secure

    Easily give and restrict access to the applications based on a user’s role in the organization with role-based security.

    Tec Specs

    System Requirements

    Management Console and Service
    • Windows 7 SP1+
    • Windows 8+
    • Windows 10
    • Windows Server 2008 SP1
    • Windows Server 2008 R2
    • Windows Server 2012
    • Windows Server 2012 R2
    • Windows Server 2016
    SQL Server Repository
    • SQL Server 2008
    • SQL Server 2008 R2
    • SQL Server 2012
    • SQL Server 2014
    • SQL Server 2016
    Monitored SQL Servers
    • SQL Server 2008
    • SQL Server 2008 R2
    • SQL Server 2012
    • SQL Server 2014
    • SQL Server 2016
    • SQL Server 2017
    Cloud
    • SQL BI Manager runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports Microsoft SQL Server instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2).
    Browser Support
    • Internet Explorer 10+
    • Microsoft Edge
    • Chrome
    • Firefox

    Version History

    Version 2.2
    • Alerting: Set alert thresholds based on relevant metric precision
    • Query monitoring: Collect queries constantly and save query history
    • SSRS monitoring: Register SSRS instances for scale-out deployment
    • User management: Limit access to managed instances based on product user login
    • Bug fixes
    Version 2.1
    • Drill down into SSIS packages to identify performance issues and package failures at the task level
    • Support for SQL Server 2016

    Version 2.0

    • Dashboard, charting, and UI enhancements.
    • Support in SSAS for both Multidimensional (MOLAP, Cubes) and Tabular Models.
    • Over 20 additional metrics for SSAS monitoring.
    • More in depth SSRS monitoring of reports, subscriptions, and parameters.
    • Monitoring of SSIS package execution and historical performance.
    • Additional enhancements and bug fixes
    Version 1.5

    Reporting and alerting enhancements including:

    • Reporting on user activity for SSAS, SSRS
    • Alerting and reporting improvements

    New dashboard widgets
    Additional Enhancements and bug fixes

    Version 1.1

    Additional data viewing and handling capabilities including:

    • Dashboard – View active sessions for top 10 SSAS instances, view running jobs for top 10 SSIS instances, view active sessions for top 10 SSRS instances.
    • SSRS Performance – Show export data, availability over time, and month and year projections of the data.
    • Administration – Import data, modify monitoring settings, and copy alert thresholds from one instance to another.
    Resources
    null
    SQL BI Manager Datasheet
    Everything you need to know, all in one downloadable PDF.
    DOWNLOAD THE DATASHEET
    null
    View a Democast
    Sign up for the next Live Demo!
    REGISTER FOR A DEMOCAST
    Tour

    SQL Business Intelligence Manager Product Tour

    Monitor performance of SQL Server BI systems : SQL Business Intelligence (BI) Manager provides comprehensive and agentless monitoring of the servers and services for SQL Server Analysis Services (SSAS), Reporting Services (SSRS), and Integration Services (SSIS). Monitor the health and availability of your entire SQL Server BI environment with a dashboard that displays an alert status and enables you to drill down to find details relating to performance and availability issues.

    Configure alerts for BI services : The Alerts view displays all of the current alerts for the monitored BI services along with the historical alerts. Email notifications alert you when services are performing poorly through the configurable alerts functionality. Set your thresholds to trigger the alerts for a variety of BI components such as report generation performance and memory and CPU usage of a service.

    View SSRS report history : The SSRS report history shows all reports executed with status, type, executing user, and any report parameters. View SSRS performance counters and report execution activity to monitor how long it takes reports to run, which ones did not run, and the impact on server resources. View by user, session, and processing time.

    View monitored SSAS services : Monitor SSAS performance and processing metrics, query activity, cache, sessions, object utilization, and user activity. SQL BI Manager displays the list of monitored service instances for each service and general information about the service instance. Performance information pertaining to a variety of metrics is accessible by selecting a specific service instance.

    Review SSIS execution history : The SSIS execution history allows you to search for a particular package execution and then drill down into the steps executed and see performance statistics and status. Upon selecting a step, you can view any warning or error messages associated with that step. View SSIS activity to monitor integration package status, execution duration, and any error occurrences.

    Download

      START FOR FREE

      No credit card required. Fully functional for 14 days!

      Buy Now

      Includes first year of maintenance.
      Volume discounts available

      Add to Cart
      Request a Quote

      Live Product Demo

      See SQL BI Manager in action with a seasoned pro.

      Request a Demo
      START FOR FREE

      No credit card required. Fully functional for 14 days!