From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Database server maintenance plans

Database server maintenance plans - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Database server maintenance plans

“

- [Instructor] SQL Server 2016 includes the ability to create automated maintenance plans that will help keep the server running in tip-top condition. With a maintenance plan, the server can monitor itself for inconsistencies, and help guard against performance degradation. They can be developed using a graphical wizard, or written with T-SQL commands for deeper levels of control. These instructions will build a workflow that steps through a variety of typical maintenance tasks, such as rebuilding indexes, creating backups, and performing consistency checks. These tasks can get grouped into a subplan so that they're easier to manage and update, and each subplan can get scheduled to run at different times depending on the requirements of the database's design. So what exactly can a maintenance plan do? First, they can reduce the size of database files on disk by performing data compression, and removing empty database pages. They can build indexes and balance the amount of data…

Contents