Customizing the Queries

You can customize which queries get run and how long they wait by editing querymanifest.json and the queries in the SQLServerCheckup folder.

Changing Timeouts and Queries

In the Resources folder, open querymanifest.json with a text editor. Keep in mind that any customizations you make will be lost when you get an updated version of SQLServerCheckup.exe.

If you want to let a query run longer, like if you’re dealing with a dramatically underpowered server and you’re willing to use more resources for an extended period of time, then edit the “Timeout” property for that query. Only change this for specific queries that are running into timeout problems, not across the board.

If you want to skip a query entirely, simply remove its section from querymanifest.json.

Adding More Queries

As of the current release, adding queries isn’t exactly easy. A future version of SQLServerCheckup will make it easier to add queries, and keep your customizations as you get updated versions of SQLServerCheckup. For now, adding queries involves adding additional sections to querymanifest.json and additional tabs to the spreadsheet.

The SourceColumnName in querymanifest.json must exactly match the SQL Server query’s results.