O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

A Performance and Tuning Methodology

A methodology is a process or procedure designed for repeatability that has been proven to work for a certain paradigm. In our case, it is a repeatable and thorough SQL Server–focused performance and tuning process. We generalized this focused process into a repeatable methodology and identified two possible paths that can be taken through it: one for a new SQL Server implementation that will have performance and tuning designed into it from the start and another for performance and tuning of an existing SQL Server implementation (one that needs to be scaled out or rescued—or in other words, “optimized”).

Figure 38.4 illustrates this overall performance and tuning methodology within a traditional waterfall ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required