This article only applies to Squared Up Version 2.0. If you're looking for help with Squared Up Version 3.0, please visit our new knowledge base

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.