Chapter 2

Optimizing the Performance of Queries

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Troubleshoot and maintain query performance.
    • Identify poorly performing queries.
    • Analyze a query plan to detect inefficiencies in query logic.
    • Maintain and optimize indexes.
    • Enforce appropriate stored procedure logging and output.
  • Troubleshoot concurrency issues.

images As a continuation of Chapter 1, “Optimizing the Performance of Databases and Database Servers,” you'll now turn your attention to specifically optimizing the performance of queries within the SQL Server 2005 environment.

The DBA often has to optimize the performance of queries in response ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial