Monitoring and Maintaining a Database in SQL Server 2005


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


Overview/Description
To monitor a database, automate database maintenance tasks, and configure reporting services for 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.1

Lesson Objectives

Monitoring and Maintaining a Database in SQL Server 2005

  • identify the steps for establishing a performance baseline.
  • use SQL Server Profiler to monitor a database in a given scenario.
  • recognize how to tune a database using the Database Engine Tuning Advisor in a given scenario.
  • monitor and tune a database using SQL Server Profiler and Database Engine Tuning Advisor.
  • recognize how to automate database administration tasks using SQL Server Agent in a given scenario.
  • recognize how to create alerts and operators in a given scenario.
  • create and implement a database maintenance strategy for a given scenario.
  • recognize how to use the Maintenance Plan Wizard to automate database maintenance tasks.
  • manage reports in SQL Server 2005.
  • configure reporting services in SQL Server 2005.

    • Course Number:
    237874_eng