Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
We host a web application for customers, sometimes they call in and complain of slowness. I was asked to have a list of things to check from network down to the application.
For SQL, can any suggest any quick queries that can be run or any good commercial tools that could be purchased that would quickly determine if SQL is the root cause or is otherwise healthy?
The Brent Ozar Unlimited First Responder Kit is a good and free place to start. It will walk you through looking for slow queries and comes with a handy worksheet of what to do.
If you need a commercial tool then SQL Sentry Performance Advisor would likely get you to the bottom of it the fastest; it will capture queries, query times, query plans, and query aborts - but specifically it also has the best visualisation and graphing of the bunch.
It's quite pricey but they have a fully functional trial.
