You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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 transactionsAverage 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 Memory Cache charts.
    • CPU
      Displays CPU Thread SwitchingPercent Process TimePercent 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 UsageAvailable Memory, and Page Transactions.

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 > >

  • No labels