BI services monitoring
- SQL BI Manager fails to register BI services for monitoring if a local SQL Server instance is not installed on the host machine.
In SQL BI Manager 1.0, any BI service must have a local instance of SQL Server installed to be registered for monitoring. For machines where a BI service is running without a local SQL Server instance, installing a copy of SQL Server Express on the target machine allows those services to be monitored. This limitation will be corrected in an upcoming release.
- The Remove option in the BI Services views removes the monitored BI service instance.
Users that want to stop monitoring a specific BI service should use “Disable Monitoring” which is accessible through the “gear” icon to the right of the service instance name in the service (SSAS, SSRS, SSIS) view. Selecting Remove will remove the service instance and any associated monitored BI services will stop collecting data and sending alerts as a result.
Adding users
- SQL BI Manager fails to add a user if he/she lacks an account on the local SQL BI Core Repository.
SQL BI Manager is designed to add users and grant access as needed. However, users that lack an account on the local SQL BI Core Repository fail to be added as new users in the Administration tab. Please register new users with the SQL BI Core Repository before adding them to SQL BI Manager.
- New SQL BI Manager users may experience issues when logging into SQL BI Manager console.
Some recently added users may experience issues when login in the SQL BI Manager console regardless of their Administration or Read-Only privileges, or correct Windows credentials. An incorrect user name or password message displays. This is a result of the above requirement to register new users with the SQL BI Core Repository before adding them to SQL BI Manager.
Alerts/Data
- Some SQL Server Reporting Services performance counters are not available for SQL Server 2008.
Windows Service First Session Requests/sec and Snapshot Updates/sec are not available for SQL Server 2008 in the SSRS performance view.
- SQL BI Manager occasionally returns wrong CPU Usage Percent values for the SSAS, SSRS, and SSIS roll-up views.
Users may find that occasionally the CPU Usage Percent values for the SSAS, SSRS, and SSIS roll-up views of the main dashboard are incorrect.
- Cube information for SQL Server Analysis Services fails to display in the SQL Server 2008 X86 version.
SQL BI Manager is designed to display and report on database cube information for SQL Server Analysis Services. However, an issue in the SSAS Performance view results in an empty view for the x86 version of SQL Server 2008.
- The following SSAS metrics are not collected for this release:
Cache: <Inserts/sec, Evictions/sec, KB added/sec>
Processing: Rows Written/sec
Processing Aggregations: Rows Created/sec
Processing Indexes: Rows/sec
Storage Engine: Data Read from Data File
Storage Engine: Dimension Cache <lookups/sec, hits/sec>
Storage Engine: Flat Cache <lookups/sec, hits/sec>
Storage Engine: Measure Group Cache <lookups/sec, hits/sec>
Storage Engine: Calculation Cache <lookups/sec, hits/sec>
Threads: Processing Pool Job Queue Length
- The following SSRS metrics are not collected for SQL Server 2008 in this release:
Cache Flushes/Sec
Delivers/Sec
Events/Sec
Snapshot Updates/Sec
Total App Domain Recycles
Online Help
To access the online documentation within the SQL BI Manager application select “Help” from the “gear” icon drop-down menu. You may also access through the following link: wiki.idera.com/display/SQLBI General
- BI Services charts in SQL BI Manager display metric data only in the 'Minutes' scale.
Charts in the SSAS, SSRS, and SSIS performance views display metric data only in the 'Minutes' scale. Scale drop-down options for Hour, Day, Week, and Month are not available in this release.
- The My Environment section of the SQL BI Manager's dashboard does not include monitored BI Service Instance information.
For this release, users should be aware that the information displayed at the top right in the DASHBOARD view (UP, DOWN, CRITICAL) encompasses the total number of monitored BI Service Instances and may be different than the number of monitored servers.
- The Disable Monitoring option in the BI Services performance views disables only a specific BI service.
For this release, users should be aware that when using the option to Disable Monitoring, available in the SSAS, SSRS, and SSIS performance views, only the specific BI service is disabled. This information is reflected in MY ENVIRONMENT under "Disabled Instances" from the DASHBOARD VIEW.
- An option to manually refresh data is not available in all SQL BI Manager views.
SQL BI Manager is designed to collect data and set alerts every 6 minutes. Displayed data may be manually refreshed by selecting F5.
- An option to modify the number of rows displayed is not available in the dashboard.
SQL BI Manager displays by default 10 rows in the different widget sections of the main dashboard. It is not possible to modify this value in this version.