C H A P T E R  12

Automating Routine Maintenance

One of the biggest responsibilities you have as a DBA is proactively making sure that all the servers in your environment are running smoothly. You should not wait for a user to call and complain about slow response times before rebuilding indexes or updating statistics. Also, if you encounter an issue, such as a torn page in a database, it is better to find out sooner than later. If an issue goes undetected long enough, you may not have the backups needed in order to correct it, and your only option may be to accept data loss. Sustaining a SQL Server instance that provides optimum performance requires constant maintenance. Luckily, you can use the same tools within SQL Server to automate maintenance ...

Get Pro SQL Server 2012 Administration now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.