Are your SQL Servers healthy? If the things went south today today, would you be able to say you can recover confidently?
If you are unsure, it is time to find out. And if you are sure, its time to verify. As DBAs, it is our duty to think of the worst ways in which our database platforms can extinguish themselves and plan accordingly. As part of that missions, we need to be certain to check up on our environment.
A number of changes for this month. Some specific changes are the releases of new cumulative updates for SQL Server and the RTM of SQL Server 2012. You can follow for these changes as well from Microsoft on the release blog. There is also a new section on Windows Server. After a few SQL Server Health Checks I’ve done in the past couple months, its become clear that, as DBA’s, we need to put forth more effort to make sure this is also being updated.
Monthly Checklist
- Backup Validation: Check everything involved in the backup process. Are your backups executing as desired? Are the monitoring jobs properly alerting to failures? Have their been any unexpected failures? Have backup duration times changed?
- Recovery Validation: Is everything for your recovery collected and being backed up? Have you practiced restoring at least one of your SQL Server databases from production in the last month?
- SQL Server Updates: Is your SQL Server environment up-to-date? Check each of your instances and review the most recent releases of SQL Server. Make a plan to determine when the most recent updates will be applied. Also, be aware that support for SQL Server releases do end at some point. Support for the version of SQL Server that you are currently using may no longer be supported.
- SQL Server 2012 RTM (Evaluation)
- SQL Server 2008 R2 SP 1 CU5
- SQL Server 2008 R2 SP 1
- SQL Server 2008 R2 CU 12 – Support ends 7/10/2012
- SQL Server 2008 SP 3 CU 3
- SQL Server 2008 SP 3
- SQL Server 2008 SP 2 CU 8 – Support ends 10/9/2012
- SQL Server 2008 SP 2 – Support ends 10/9/2012
- SQL Server 2008 SP 1 CU 16 – Support ends 10/11/2011
- SQL Server 2008 SP 1 – Support ends 10/11/2011
- SQL Server 2008 CU 10 – Support ended 4/13/2010
- SQL Server 2005 SP 4 CU 3 – Mainstream support ended 4/12/2011
- SQL Server 2005 SP 4 – Mainstream support ended 4/12/2011
- Check wait stats.
- Analyze your indexes (via IndexAnalysis)
Something Missing?
Is there something missing in this list that you think should be included? Leave a comment and I’ll add it in for next month. I’ll follow-up next month on the first Monday of the month and we’ll see how everyone that reads this is doing.
Related posts:
- January 2012 – Monthly SQL Server Checklist
- February 2012 – Monthly SQL Server Checklist
- September Monthly SQL Server Checklist
