Microsoft® SQL Server 2012 Unleashed

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