Advertisement

Performance Tuning and Optimization

  • Robert E. Walters
  • Grant Fritchey
  • Carmen Taglienti

Abstract

SQL Server 2008 and the Windows operating systems that it runs on perform very well storing, maintaining, and presenting data to your users. Many of the processes that make them run this well are built into SQL Server 2008 and the OS. Sometimes, because of a variety of factors, such as data changes, new code, or poor design choices, performance can suffer. To understand how well your server is performing, or not, you need to understand how to measure its performance.

Keywords

Graphical Plan Data Collector Queue Length Central Processing Unit Execution Plan 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Robert E. Walters, Grant Fritchey, and Carmen Taglienti 2009

Authors and Affiliations

  • Robert E. Walters
  • Grant Fritchey
  • Carmen Taglienti

There are no affiliations available

Personalised recommendations