Titolo: Troubleshooting Performance Problems in SQL Server 2005
Autore: Sunil Agarwal, Boris Baryshnikov, Tom Davidson, Keith Elmore, Denzil Ribeiro, Juergen Thomas
Sommario: It is not uncommon to experience the occasional slow down of a SQL Server database. A poorly designed database or a system that is improperly configured for the workload are but several of many possible causes of this type of performance problem. Administrators need to proactively prevent or minimize problems and, when they occur, diagnose the cause and take corrective actions to fix the problem. This paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as SQL Server Profiler, System Monitor, and the new Dynamic Management Views in SQL Server 2005.
Titolo: Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005
Autore: Arun Marathe
Sommario: This paper explains how batches are cached and reused in SQL Server 2005, and suggests best practices on maximizing reuse of cached plans. It also explains scenarios in which batches are recompiled, and gives best practices for reducing or eliminating unnecessary recompilations.
Titolo: Forcing Query Plans with SQL Server 2005
Autore: Burzin A. Patel
Sommario: This paper explains the USE PLAN query hint and the Plan Guides feature that are introduced in Microsoft SQL Server 2005. This paper also demonstrates how they can be used individually, or together, to force the selection of specific query execution plans for a variety of scenarios.
Titolo: How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888
Autore: Bob Dorr, Sameer Tejani
Sommario: Error messages 17887 and 17888 are new health monitoring conditions that were added in SQL Server 2005. This white paper outlines the conditions in which these errors can be reported and what steps the database administrator can take to both understand and remedy these errors.
Titolo: Working with tempdb in SQL Server 2005
Autore: Wei Xiao, Matt Hink, Mirek, Sunil Agarwal
Sommario: This white paper describes how SQL Server 2005 uses tempdb. Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot. A case study that uses a workload similar to TPC Benchmark H (TPC-H) shows new ways to manage and troubleshoot tempdb resources. This paper also includes items to consider when upgrading to SQL Server 2005 and configuring tempdb.