Microsoft® SQL Server 2008 R2 Unleashed

Performance and Tuning Design Guidelines

We outline some of the major performance and tuning design guidelines here. There are, of course, many more, but if you a least consider and apply the ones outline here, you should end up with a decently performing SQL Server implementation. As we have described previously, performance and tuning should first be “designed in” to your SQL Server implementation. Many of the guidelines discussed here can be adopted easily in this way. However, when you put off the performance and tuning until later, you have fewer options to apply and less performance improvement when you do make changes. Remember, addressing performance and tuning is like peeling an onion. And, for this reason, we present our guidelines ...