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
- Package Id
- Package Name
- Status
- Package Start
- Package End
- Duration
- Error Count
- First Error Message
- Configuration Message
The items displayed in this list can also be filtered by Package Name, Status, and User.
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 > >