New features

• FIPS Compatibility

SQL BI Manager now supports running on servers subject to Federal Information Processing Standards. for more information about FIPS compatibility, see Ensure FIPS compliance.

•  Data Export

All SQL BI Manager charts allow you to export data in a CSV format. CSV allows you to later create a spreadsheet using a product such as Microsoft Excel.

• Enhanced SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) functionality

This release includes the following enhancements regarding SQL Server Reporting Services (SSRS) monitoring:

• • Display, report, and define alerts based upon CPU utilization.
  • Display the top 10 reports based on how often run,  total processing time, average processing time, and most active user.
  • Display the top 10 most active users.
  • Use an enhanced list of performance metrics including as I/O activity, total processing time, average processing time, and longest running report.

This release includes the following enhancement regarding SQL Server Analysis Services (SSAS) monitoring:

• • Display the top 10 most active users and include drill-down capability to display data related to user activity.

• Integration with the IDERA Dashboard

IDERA SQL BI Manager 1.1 now integrates with the IDERA Dashboard, a common technology framework, designed to support the IDERA product suite. Users are able to obtain an overview of the status of their SQL Servers and hosted databases all in a consolidated view and navigate to individual product dashboards for details. The IDERA Dashboard provides a central set of services for managing users, product registry, instance registry, aggregated alerts across IDERA applications, a central web server, and tags for grouping instances. For additional information, see Integration with the IDERA Dashboard.

• Support for SQL Server 2008-2012 versions

IDERA SQL BI Manager 1.0 supports SQL Server versions 2008, 2008 R2, 2012, and 2014.

• Agentless BI Monitoring

IDERA SQL BI Manager 1.0 provides agentless monitoring of the health and availability of your BI environment.

• SQL Server Analysis Services Monitoring

Provides monitoring of SQL Server Analysis Services and the server they reside on including OS counters, performance counters as well as active SSAS sessions and resource utilization.  For additional information, see SSAS performance view.

• SQL Server Reporting Services Monitoring

Provides monitoring of SQL Server Reporting Services and the server they reside on including OS counters, SSRS Report Server counters, SSRS Web Server counters, and  SSRS Windows Service counters.  For additional information, see SSRS performance view.

• SQL Server Integration Services Monitoring

Provides monitoring of SQL Server Integration Services and the server they reside on including OS counters and performance counters.  For additional information, see SSIS performance view.

• Broad Visibility into SQL BI Manager

Over 140 metrics across SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services to keep you informed about the health and availability of both the service as well as the server they reside on. 

• Roll Up Dashboard

An intuitive dashboard interface allows you to quickly get a high-level overview of your BI environment and display details on BI environment issues through the drill down capability from the top level view.  For additional information, see Viewing information on the dashboard.

• Alerts View and Configurable Alerts

The Alerts view and email alerting keeps you informed on critical issues pertaining to the health and status of your BI environment. You can configure alert threshold levels according to what is suitable for your BI environment. For additional information, see Configuring alert thresholds.

• Security

Role-based security makes it easy to give and restrict access to just the appropriate individuals. For additional information, see Adding users.