SQL Server 2005 Database Performance and Optimization

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


To monitor and optimize database performance using SQL Server utilities

Target Audience

Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others


This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation

Expected Duration

155 min.

Course Objectives

SQL Server 2005 Database Performance and Optimization

  • configure SQL Server Profiler Trace files in a given scenario.
  • configure System Monitor to monitor SQL Server performance in a given scenario.
  • use SQL Server Profiler and System Monitor to monitor an instance of SQL Server 2005.
  • recognize the features and functionality of Database Engine Tuning Advisor.
  • use Database Engine Tuning Advisor to tune a SQL Server database in a given scenario.
  • tune a SQL Server database using Database Engine Tuning Advisor.
  • retrieve SQL Server state information using dynamic management views (DMVs) in a given scenario.
  • query dynamic management views and functions.