Microsoft® SQL Server™ 2000 Unleashed, Second Edition

Performance-Monitoring Approach

Taking a closer look at the performance-monitoring handles depicted in Figure 37.1, you can see that SQL Server spans all of them. SQL Server must process requests submitted to it via the network, service these requests with one or more processors, and rely on accessing a request's data from both memory/cache and the disk system. If you maximize utilization on these resources from the point of view of SQL Server and the operating system, you will end up with a well-tuned database server.

One area of interest is the amount of network traffic that is handled by SQL Server and the size of these network requests. Another area of interest is the ability of the available processors to service the load presented to them ...