Versions Compared

Key

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

 

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.

...

    • Server
    • User Id
    • Package Id
    • Package Name
    • Status
    • Package Start
    • Package End
    • Duration
    • Error Count
    • First Error Message
    • Configuration Message

 

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 XLS or XML file. You can also print a specific chart or download it as a PNG, JPEG, PDF, or SVG file.

...