SQL Performance Diagnostics Utility

I work tech support for a software company who uses SQL to store application configuration/events/user data etc. Occasionally we encounter problems related to SQL performance, and it can be challenging to determine if it’s a SQL issue or application issue and to get down to the root cause.

I recently spent a couple hours with a DBA who pointed me to the scripts at https://www.brentozar.com which are provided at no cost and do a great job pulling out details about the most expensive queries, blocking, etc.

Since our customers aren’t DBAs and our support team has limited SQL ability, I wrote a simple application to install and execute the stored procedures. The results are saved to the database, and the tool creates a backup of said database.

It’s nothing terribly special or difficult, but should save us a lot of time gathering information for these types of cases.


submitted by /u/Shermer26
[link] [comments]

Leave a Reply