SQL BI Manager monitors several type of metrics to provide accurate information about the status and health of the Integration 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
SSIS Activity
This category displays a list of all activity related to the Integration Services within the BI environment. The list includes the following information:
- Server
- User Id
- Package Id
- Package Name
- Status
- Package Start
- Package End
- Duration
- Error Count
- First Error Message
- Configuration Message
You can modify the time frame and the scale (minute, hour, day, week, or month) used to display the information 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 > >