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 ...
Get Learn SQL Server Administration in a Month of Lunches now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
