1 minute readApplies to: v4

Operations Manager 2012 Data Warehouse Health Check Script

Squared Up 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.

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