Optimizing SQL Server 2005 Performance

This course is included in our On-demand training solution.

Overview

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

180 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?