Microsoft® SQL Server 2012 Unleashed

Summary

In this chapter, you saw the difference a formal performance and tuning methodology can make when applied to completely new SQL Server–based implementations. We also showed you a modified version for attacking performance issues you might have with your existing SQL Server deployment. You should use the one that fits your needs best and guarantees you a great-running SQL Server implementation. But you need to use something that you can follow to the letter so that nothing falls between the cracks. We also outlined a series of performance and tuning guidelines for you that correspond with all the major layers of your SQL Server environment. You should take these along with you to every design review, code walkthrough, or solution architecture ...