It’s the first Monday of the December, and it’s time to do a monthly checkup. As previously mentioned, the premise of this post is to help DBAs maintain their environments by getting together a monthly checklist and running through it every month.
Now, if you were paying attention last month, you would have noticed that there wasn’t a November checklist. We all get busy from time to time, and for me that was last month. There’s no reason to forget to checkup on your servers. But it can happen from time to time.
When you miss a check up, there are two things that you are going to want to make sure that you do. First, make certain that you don’t miss doing you checkup the next time it comes up. Don’t let a bump in the road be the end of the road. Next, own the mistake, and don’t try to hide it. I missed last month’s post and it’s become a topic of discussion here. If you miss a checkup on your servers, let your manager know, and figure out what caused this to happen. Maybe there’s too much on your plate and it’s time for new tools, a new hire, or some outside assistance.
There are a number of changes to this month’s checklist. First, there have are a few cumulative updates to check out depending on your environment. Second, SQL Server 2012 RC0 has been released and it’s time to get that downloaded to see if it can help streamline your environment and improve your daily life.
- 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 the support for SQL Server releases does end at some point.
- SQL Server 2012 RC0
- SQL Server 2008 R2 SP 1 CU3
- SQL Server 2008 R2 SP 1
- SQL Server 2008 R2 CU 10 – Support ends 7/10/2012
- SQL Server 2008 SP 3 CU 2
- SQL Server 2008 SP 3
- SQL Server 2008 SP 2 CU 7– 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)
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.