Monitoring and Maintaining a Database in SQL Server 2005

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

Overview

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

185 min.

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



     

    NEED HELP OR NOT SURE?