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.

label: Operations Manager 2012 Data Warehouse Health Check Script keywords: Tao Yang Data Warehouse health check operations manager 2012 dw performance speed database db health script health healthcheck rank: 1