Summary

Correct administration and maintenance will go a long way in the battle to keep your servers upand this means more than performing regular backups . Whether it is securing your instance, performing proactive index maintenance, tuning memory, or moving objects, the little things make a big difference. You should definitely not implement or change your current administrative procedures without correct testing and commitment.

Now that you have learned what it takes to administer your SQL Servers for high availability, it is time look at how you can be proactive in understanding the health of your SQL Server through monitoring.