SQL Data Collector

How to use the SQL Data Collector

Download the zip file and extract that in an easy-to-find folder like C:\temp, and then open a command prompt, navigate to that folder, and type:

SQLServerCheckup.exe –s MYSERVERNAME

If you use SQL authentication to connect to the server, you can specify a username & password:

SQLServerCheckup.exe –s MYSERVERNAME –i MYUSERNAME –p MYPASSWORD

It takes about 5-15 minutes to run a bunch of low-overhead, low-priority queries and packages the results up into a zip file. It doesn’t change anything on your server or block queries – it just gathers metrics. If you get any errors in the app, absolutely no worries – they’ll be logged and sent to me too.

After it runs, go into the Output folder and email me the zip file. (If you’re curious about what’s in it, you’re welcome to look at the results – the more you know about your SQL Server, the better!)