Operations Manager 2012 Data Warehouse Health Check Script

SquaredUp DS asked Tao Yang to build a Health Check tool specific to OpsMgr Data Warehouse databases, in order to help identify and troubleshoot the performance related issues with the Data Warehouse. Tao has produced a script which focuses on the Data Warehouse component, and produces a HTML report.

The report produced consists of the following sections:

  • Management Group Information
  • Data Warehouse SQL Server information
  • Data Warehouse SQL DB information
  • Temp DB configuration
  • SQL Service Account Configuration
  • Data Warehouse Dataset Configuration
  • Key SQL and OS performance counters
  • Collect Data Warehouse performance related events from each management server

For more information and the downloadable scripts click here Data Warehouse Check Health Script.

Was this article helpful?

Have more questions or facing an issue?