Page History
...
- Disk
Includes the following charts: Disk transactionsTransactions, 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 Cache Faults charts. - CPU
Displays CPU Thread SwitchingSwitching (Threads Waiting vs. Thread Switches), Percent Process Time (Percent Privileged Time vs. Percent User Time), Percent Processor Time (Processor Time vs. SSIS Processor Time), and Interrupts per Second chartscharts. - Processing
Displays a Process Working Set (Memory Working Set Vs. SSAS SSIS Working Set) chart. - Memory
Includes the following charts: Memory Overall Usage, Available Memory, and Page Transactions.
- Disk
...
This category displays a list of all activity Package Executions related to the Integration Services within the BI environmentinstance, with drill down capabilities. The list includes the following information:
- Server
- User
- Package IdID
- Package Name
- Status
- Package Start
- Package End
- Duration
- Error Count
- First Error Message
- Configuration Message
You can click the Package Name to populate the Package Details list below, which contains the following information:
- Execution ID
- Folder Name
- Environment Name
- Project Name
- Step Name
- Execution Duration
- Start Time
- End Time
- Step Result
If you click the Step Name, BI Manager displays additional information for the task, organized in a list with the following columns:
- Operation ID
- Message TIme
- Message Type
- Message
- Event Name
- Package Step
The items displayed in
...
the Package Execution list can
...
be filtered by Package Name, Status, and User. The information can also be exported to a PDF, XLS, or XML file.
Note |
---|
To obtain SSIS Activity, deploy packages in one of the following ways:
|
SSIS History
This category displays Package Monitoring information. The Package History list includes the following columns:
- Server
- Package
- Average Execution Time
- Last Execution Date
- Last Execution Status
You can click a Package from the Package History list to view detailed Execution History information. Use the and icons to toggle between a list view and a chart view of the Execution History.
The items displayed in the Package Monitoring list can be filtered by Server. The information from both the Package History and the Execution History can be exported to PDF, XLS, or XML files.
Tip |
---|
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 an 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 > >
...
...