Performance Tuning

  • Miguel Cebollero
  • Jay Natarajan
  • Michael Coles
Chapter

Abstract

In most production environments, database and server optimization have 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. This chapter discusses various tools and strategies for query optimization and performance enhancement and tuning queries.

Keywords

Execution Plan Query Performance Query Plan Query Engine Data Page 
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.

Copyright information

© Miguel Cebollero 2015

Authors and Affiliations

  • Miguel Cebollero
    • 1
  • Jay Natarajan
    • 1
  • Michael Coles
    • 1
  1. 1.ValricoUnited States

Personalised recommendations