Performance reports from Servers

Dashboard Server
, ,
1

I’m looking to get a bit of a report of performance on some of our main SQL Servers when it comes to the likes of CPU Utilisation, Disk I/O, Disk Latency etc.

What is the best way we can get some reports for these metrics from SCOM 2012R2?

2

Hi

I wouldn’t start with the SCOM out of the box reports. They are poor beyond belief. If it is an actual report then try out the Veeam reports which are significantly better: https://www.veeam.com/report-library-system-center.html

The other option is to go the SQL Query approach. Query the DW directly which will have:

  • 10 days of raw data
  • 400 days of aggregated data (hourly \ daily)
This can then be exposed via Power BI:

https://blogs.technet.microsoft.com/askpfeplat/2016/03/28/using-power-bi-to-create-kpi-reports-from-system-center-operations-manager/

http://blogs.catapultsystems.com/cfuller/archive/2015/12/01/using-power-bi-for-disk-space-dashboards-and-reports-in-operations-manager/

https://blogs.technet.microsoft.com/drewfs/2014/08/17/scom-performance-data-and-power-view/

You could also potentially look to do this via Squared Up if you had a perspective with all the objects you want using the export data functionality.

Cheers

Graham

1 Like