Run the Health Check Tool

Run the Health Check Tool to monitor and optimize system configurations that impact performance. You can select which tests to run and then save the results to a file.

You can run the Health Check Tool for both hosted and on-premises customers. Cherwell hosted servers run a standard SQL configuration, consequently you can disregard some Health Check Tool results for hosted customers. No changes should be made in the back-end; the adding or dropping of indexes should be made by the customer and done through the product.

For on-premises customers, prior to running the Health Check Tool you should check settings for:
  • ServerMaxMemory
  • OptimizeAdhoc

If a customer is using a dedicated server (not a shared cluster) to host the database, Cherwell recommend you set OptimizeAdHoc to true. If an on-premises database has OptimizeAdHoc set to False and is not using a shared cluster, this setting should be changed accordingly.

Good to Know

  • If you are running CSM version 7.0 or later, you can run the Health Check Tool to inspect a database.
  • We recommend that the SQL Server be running for a minimum of 3 business days before using the Health Check Tool.
  • If changes are made, again let the server run for a minimum of 3 business days before using the Health Check Tool.
  • In all cases suggestions made for adding or dropping indexes should be made by the customer and should be done through the product; no indexing changes should be made through the backend. This is to prevent the next Blueprint publish from wiping the changes out.

To run the Health Check Tool:

  1. From the CSM Administrator main window, select the Performance category.
  2. Select Run Health Check.
  3. Choose which tests to run:
    • In the Run Selected Rules pane, select the rules to check various areas of your system. The list of rules available to you may vary depending on the version of CSM and the Health Check plug-in that you have installed.
    • Select the Generate Usage Statistics check box to check system and database information.
      Some rules and usage statistics require View server state privilege for the database login account. In SQL Server Management Studio, this privilege is located on the Securables tab of the Login Properties dialog box.
    • Select the Select None link to generate CSM system and the Health Check plug-in information only.
  4. Select OK.

The Health Check results open in a separate window. Select Save to File to save the results to an HTML file; select Submit to send the results to Cherwell Support on request.