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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
