12/05/2023
SQL Server Performance tuning – High Level Steps.
When I get a call asking me to look at the database because the application is responding slowly, this is where I start:
1. What is the CPU and memory doing on the database server.
2. Are there any blocking locks on the database in question.
3. Are there any long running queries on the database in question.
4. Are there any long running queries on that database server (on different databases) using up resources.
5. Are there any indexes that can be created for the long running queries for items number 3 and 4.
6. Do stats need to be updated on the database in question.
