Chapter 22. SQL Server performance checklist
I want to wrap up with a checklist of performance items. This is a list I tend to follow whenever someone calls me and begins with a vague statement such as, “the SQL Server computer is running slowly.” That doesn’t give you much to go on, does it? A checklist helps me stay consistent, and to not overlook simple stuff. Keep in mind, too, that SQL Server isn’t always at fault—many complex applications include other servers that may contribute to performance problems. But, if you can narrow the problem down to SQL Server, then this checklist will help you solve the problem.
I should emphasize that this list focuses mostly on things that I, as an administrator, can do something about, especially when the database or server in question is supporting an application for which I don’t “own” the code. I’m focusing on the things I can do strictly on the server, without touching any programming. If you do have access to the code, or have a coworker who does, there’s obviously a lot more that you can dive into.