Advertisement

Performance Tuning

  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

Abstract

In most production environments, database and server optimization has long been the domain of DBAs. This includes server settings, hardware optimizations, index creation and maintenance, and many other responsibilities. SQL developers, however, are responsible for ensuring that their queries perform optimally. SQL Server is truly a developer’s DBMS, and as a result the developer responsibilities can overlap with those of the DBA. This overlap includes recommending database design and indexing strategies, troubleshooting poorly performing queries, and making other performance enhancement recommendations. In this chapter, we will discuss various tools and strategies for query optimization and performance enhancement and tuning the queries.

Keywords

Execution Plan Query Plan Buffer Pool Storage Engine Mixed Extent 
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

© Jay Natarajan, Rudi Bruchez, Scott Shaw, and Michael Coles 2012

Authors and Affiliations

  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

There are no affiliations available

Personalised recommendations