SQL Server 2005 Database Performance and Optimization

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

---

Overview/Description
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

Prerequisites
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 (hours)
2.6

Lesson 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.

Course Number:
234718_eng