Queries It Runs

SQLServerCheckup runs from your desktop, connects to the SQL Server of your choice, and runs a series of diagnostic queries. They are very lightweight: they don’t start traces with Profiler or Extended Events. They’re designed to capture diagnostic data quickly with a minimum of overhead.

To see the queries, go into the \Resources\SQLServerCheckup folder. They are a
collection of industry-standard open source scripts that check for things like
missing backups, corrupt databases, misconfigured memory, and more.

Nervous about what data is getting gathered? No problem: run it against a test
or development server first. After it finishes, look in the Output folder and
you can see the output.

You can also change the query timeouts and skip queries.