It’s time for a monthly reminder to review you SQL Server environment. As with anything, just because it appears to be running well, doesn’t mean that there isn’t an unknown element causing issues today or in the near future.
A good way to review your environment is to have a checklist of what needs to be reviewed. As an example of what you need to check, you can use my 10 Monthly Maintenance Tasks for SQL Server. It covers most everything in your SQL Server environment that needs to be checked. If you see anything missing from that list, please leave a comment on this post. And if there are good resources out there that should be included on the list – share those as well.
Checklist Updates
Since the last update, there have been a number of updates to SQL Server. The most important in the list is the release of Service Pack 2 for SQL Server 2012. The whole list of changes to the list are:
- Added Cumulative Update for SQL Server 2014 RTM
- Added Cumulative Update for SQL Server 2012 SP2
- Added SQL Server 2012 SP2
- Added Cumulative Update for SQL Server 2012 SP1
SOMETHING MISSING?
Is there something missing in this checklist or with the pages that has been overlooked? Any cool links that would aid in the review of your SQL Server environments? If so, leave a comment below and I’ll take a look.
