Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

    • Disk
      Includes the following charts: Disk transactionsTransactionsAverage Seconds per TransactionCurrent 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 PercentCache Copy Reads per Second, and Cache Faults charts.
    • CPU
      Displays CPU Thread Switching (threads waiting Threads Waiting vs. thread switchesThread Switches), Percent Process Time (Percent Privileged Time vs. Percent User Time), Percent Processor Time (Processor Time vs. SSAS SSIS Processor Time), andand 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 UsageAvailable Memory, and Page Transactions.

...

This category displays a list of all Package Executions related to the Integration Services instance, with drill down capabilities. The list includes the following information:

...

The items displayed in the Package Execution list can also be filtered by Package NameStatus, 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:

  1. Using the SSIS Catalog deployment model.
  2. Deploying to MSDB (configure packages for logging and use the 'Log Provider for SQL Server' as Provider type).

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 Image Added and Image Added 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 >>

...


Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...