SQL Server: Maintenance Plans
Learn how to properly configure and control essential SQL Server database maintenance using Maintenance Plans. This course is applicable to anyone responsible for SQL Server databases, with any level of SQL Server experience.
What you'll learn
Proper database maintenance is critical for making sure that database workloads perform as well as possible. One of the simplest ways to implement database maintenance is to use the built-in Maintenance Plan functionality to schedule the critical database maintenance tasks - backups, consistency checking, statistics maintenance and index maintenance. The course starts by explaining how to configure Database Mail, and Operator, and alerts, all within SQL Server Agent. It then describes all the commonly-required maintenance tasks and shows how to configure them, along with do's and don'ts, plus some of the less commonly used tasks. After that it shows how to pull these tasks together into Maintenance Plans using the Maintenance Plan Wizard, the Maintenance Plan Designer, and through Integration Services packages. Finally the course discusses some of the alternative methods of implementing database maintenance through freely-available scripts. This course is perfect for anyone who is responsible for SQL Server databases, with any level of experience, from SQL Server 2005 onward.
Table of contents
- Introduction 1m
- Configuring Database Mail 1m
- Demo: Configuring Database Mail 6m
- Demo: Viewing/Modifying Database Mail Settings 2m
- Configuring SQL Server Agent Mail Settings 2m
- Demo: SQL Server Agent Mail Settings 3m
- Configuring SQL Server Agent History Retention 2m
- Demo: Configuring SQL Server Agent History Retention 2m
- Demo: Managing Retention History with a Job 3m
- Creating SQL Server Agent Alerts 1m
- Demo: Creating SQL Server Agent Alerts 3m
- Summary 1m
- Introduction 1m
- Maintenance Plan Considerations 3m
- Back Up Database Task (Full) 2m
- Back Up Database Task (Transaction Log) 2m
- Back Up Database Task (Differential) 2m
- Demo: Back Up Database Task Configuration 4m
- Check Database Integrity Task 1m
- DBCC CHECKDB Options 2m
- Dealing with Corruption 2m
- Demo: Check Database Integrity Task 2m
- Rebuild Index Task 2m
- Rebuild Index Task (2) 2m
- Demo: Rebuild Index Task 3m
- Reorganize Index Task 2m
- Demo: Reorganize Index Task 2m
- Update Statistics Task 3m
- Demo: Update Statistics Task 2m
- History Cleanup Task 2m
- Demo: History Cleanup Task 2m
- Maintenance Cleanup Task 1m
- Demo: Maintenance Cleanup Task 3m
- Summary 1m
About the author
Jonathan Kehayias is a Principal Consultant with SQLskills. He is the youngest person ever to achieve the Microsoft Certified Master - SQL Server 2008 certification and has been a SQL Server MVP for many years. Jonathan is heavily involved in the SQL community; including being the top answerer on the MSDN Database Engine forum, writing deep technical content on his blog (plus his old blog, and answering questions as @SQLPoolBoy on Twitter. Jonathan is a performance tuning expert, both SQL Se... more