OpsMgr 2012 Data Warehouse Health Check Script Updated

1 minute read

Since I published the OpsMgr 2012 Data Warehouse Health Check Script last week, the responses I have received from the community have been overwhelming!

As I mentioned the the post that there might be potential issues when executing the script for an environment where the Data Warehouse DB is hosted on a named SQL instance, man people have reached out to me and confirmed this is indeed the case.

Over the last few days, I have been busy updating this script to address all the issues identified by the community. The version 1.1 is now ready.

I have addressed the following issues in this release:

  • Fixed the issues with named SQL instances and SQL instances using non-default ports.
  • Fixed the issue where the script failed to get management group default settings when executed in PowerShell version 5 preview.
  • Fixed the error where incorrect Buffer Cache Hit Ratio counter is presented on the report.
  • Additional pre-requisite check for PowerShell version. This script requires minimum version 3.0
  • Additional pre-requisite check to test WinRM and remote WMI connectivity to each management server
  • Fixed minor typos in the reports
  • Additional optional parameter "-OutputDir". You can now specify the script to write reports to a folder of your choice. This folder must be previously created by you. If the specified folder is not valid or this parameter is not used, the script will write the report files to the script root folder.


I have updated the original post, the updated version of the script can now be downloaded from the original link.


I’d like to thank everyone who tested and provided valuable feedback to me. This project is truly a wonderful community effort!

Leave a comment