1 minute readApplies to: v3

Operations Manager 2012 Data Warehouse Health Check Script

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

Data Warehouse Performance Tuning - 5 Point Plan

Troubleshooting the Data Warehouse connection

Tao Yang's Self maintenance MP

Squared Up Ltd. (c) 2020Report an issue with this article