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.