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.