Return
-
Title
Getting health check errors on databases that are mirrored -
Description
User keeps getting health check errors on databases that are mirrored as the health check is failing on opening the mirror. -
Resolution
At the moment, we don't have any entry to disable the health check collection on mirror database. We have raised Enhancement request JIRA-2392 to address it in a future if possible.
Obtain from support and replace ExecQueryStats.sql file with the script in diagnostic server host.
Under install_dir\Agent\conf\Package\sqlserver_spotlight\2008, and restart Diagnostic Server service. -
Defect ID
Jira -2392 -
Attachments
-
Additional Information
ExecQueryStats.sql located in SR 2306876