Microsoft® SQL Server 2008 R2 Unleashed

Performance and Tuning for an Existing Implementation

Many of you may have just skipped down to this section because you have already built something and are trying to get to some serious performance and tuning for your existing implementation. Regardless of your situation, the essence of this section is describing the methodology for isolation, identification, and migration to get your existing implementation to a well-performing and tuned implementation. We use isolation in the sense that you must isolate the major performance issues quickly, identification in the sense of locating the exact issues to focus on, and migration in the sense of having to get from the current issues to a new issue-free implementation. This last part is often incredibly ...