Optimizing SQL Server 2005 Performance


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To identify ways of optimizing the performance of SQL Server 2005

Target Audience
Professionals pursuing a career as a Database Administrator

Prerequisites
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.

Expected Duration (hours)
3.0

Lesson Objectives

Optimizing SQL Server 2005 Performance

  • recognize how to optimize server performance using memory configuration options in a given scenario.
  • recognize how to optimize server performance using I/O configuration options and Windows options in a given scenario.
  • recognize how to troubleshoot database performance in a given scenario.
  • troubleshoot the performance of SQL Server 2005 in a given scenario.
  • troubleshoot and analyze query performance in a given scenario.
  • optimize database indexes in a given scenario.
  • recognize how to optimize stored procedures in a given scenario.
  • identify considerations when managing concurrent data access in a given database scenario.
  • identify and troubleshoot query performance issues in SQL Server 2005.

    • Course Number:
    237852_eng