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

Summary

Attacking SQL Server performance is not a simple task because so many variables are involved. Tuning queries and a proper database design are a huge part of this, but dealing with SQL Server as an engine that consumes resources and the physical machine is equally important. This is why it is so critical to take an orderly, methodical approach when undertaking this task. As pointed out in this chapter, you need to basically peel apart the box on which SQL Server has been installed, one component at a time (network, CPU, memory, and disk). This way, you can explore the individual layer or component in a clear and concise manner. Within a short amount of time, you will be able to identify the biggest performance offenders and resolve them. ...

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