O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

A Performance Monitoring Approach

If you take a closer look at the performance monitoring areas depicted in Figure 35.1, you can see that SQL Server spans them all. SQL Server must process requests submitted to it via the network, service those 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 end up with a well-tuned database server. However, an optimally tuned system doesn’t guarantee good performance. It’s still important to have a good database design and to implement optimal index strategies. The whole picture is important to tuning your SQL Server implementation, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required