Monitoring and Maintaining a Database in SQL Server 2005
This course is included in our On-demand training solution.
To monitor a database, automate database maintenance tasks, and configure reporting services for SQL Server 2005
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.
Monitoring and Maintaining a Database in SQL Server 2005identify 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.