SQL BI Manager monitors several type of metrics to provide accurate information about the status and health of the Reporting Services and the instances hosting these services on a BI environment. The metrics are classified in the following categories:
Server Performance
This category contains the following server related performance metrics:
- Disk
Includes the following charts: Disk transactions, Average Seconds per Transaction, Current Disk Queue Length, and Percent Idle Time. - Network
Includes Data Transfer (bytes/sec) and Network Output Queue Length charts. - Cache
Includes Cache Copy Read Hits Percent, Cache Copy Reads per Second, and Memory Cache charts. - CPU
Displays CPU Thread Switching, Percent Process Time, Percent Processor Time, and Interrupts per Second charts. - Processing
Displays a Process Working Set (Memory Working Set Vs. SSAS Working Set) chart. - Memory
Includes the following charts: Memory Overall Usage, Available Memory, and Page Transactions.
- Disk
Report Server Performance
This category contains the following SSRS related performance metrics:
- Connections
Displays charts for Active Connections and Logons, - Network
Includes Bytes Transferred and HTTP Errors charts. - Memory
Displays charts for Memory Pressure State, Memory Shrink Amount, and Memory Shrink Notifications. Requests
Includes charts for Request Activity, Unauthorized Requests, Requests Rejected, Request Volume, and Tasks Queued.
- Connections
Reporting Services
This category includes the following metrics:
- Sessions
Displays Active Sessions, First Session Requests, and Next Session Requests charts. - Cache
Contains charts for Cache Hits, Cache Misses, Memory Cache Hits, Memory Cache Misses, and Cache Flushes. - Requests
Includes the following charts: Report Requests, Reports Executed, Service Requests, Processing Failures, and Rejected Threads.
- Sessions
Reporting Activity
This category includes the following metrics:
- Report Execution
Displays a list containing information about Reporting Activities within the BI environment. The list can be exported to a PDF, XLS, or XML file. - Report Performance
Displays charts for Total Processing Time, Total Rendering Time, and Total Data Retrieval Time.
- Report Execution
User Activity
This category displays a list of all Users' activities within the BI environment. The list includes the following information:
- User name
- Sessions
- I/O Activity
- Total Processing Time(in ms)
- Average Processing Time(in ms)
- Longest Running Report
Click the User name to display the Sessions category list with more detailed information about all sessions performed by the user. You can also export the contents of the list to a PDF, XLS, or XML file.
You can modify the time frame for the information and the scale (minute, hour, day, week, or month) used in the charts and export the views to a XLS or XML file. You can also print a specific chart or download it as a PNG, JPEG, PDF, or SVG file.
SQL Business Intelligence Manager identifies issues within the SQL BI environment to help optimize BI service performance. Learn more > >