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.