June 2006
Intermediate to advanced
648 pages
15h 33m
English
Content preview from Administrator’s Guide to SQL Server 2005Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 5Monitoring and Optimization
In this chapter, I explain the tools and methods you can use to monitor and optimize your database servers. Monitoring is more than just observing the results of activity. Monitoring helps track down issues, determines growth patterns, and aids in optimization. I explain what you should monitor and why, and I discuss the tools at your disposal to help you along the way.
Before you begin monitoring the system for performance, growth, or other changes, you should have an idea of its original state, or at least the state it was in when you inherited it. These measurements are called a baseline, and having one is a bit like insurance: invaluable only when you need it. I show you what information to capture to ...