11.1. Monitor SQL Server

The very first step is always to establish the reason you are monitoring SQL Server. What are you trying to discover about your environment, or are you simply trying to establish a baseline for performance? Are you attempting to address a specific problem that has occurred, or are you trying to test the server under different loads? Perhaps you need to discover if a particular maintenance schedule or backup plan is effective in achieving the purpose for which it was created? You may be making decisions concerning scaling up hardware or deciding to scale out your environment. All of these are legitimate reasons to initiate a monitoring program. Monitoring should always be performed before any action is taken.

In the following ...

Get SQL Server® 2008 Administration: Instant Reference now with O’Reilly online learning.

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