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 ...

Get Administrator’s Guide to SQL Server 2005 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.