Microsoft® SQL Server 2012 Unleashed

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 ...