10 Monthly Maintenance Tasks For SQL Server

As a Database Administrator, there are certain tasks that you must complete at a fairly regular frequency. Jason Strate has put together a list of 10 things he says a Database Administrator should do each month.

sqlserver2014

Are you doing what you must to ensure that your SQL Server environment is behaving as you, or your manager, expects that it is? Whether you are veteran, involuntary, or junior DBA, there are common things that we are required to do for our SQL Servers on a regular basis.  These tasks may seem like they are relatively low level items, but they are in fact critical in maintaining the health and security of our SQL Server instances.

  1. Update Windows Server
  2. Update SQL Server
  3. Validate Backups
  4. Validate Recovery Strategy
  5. Verify SQL Server and Windows Configuration
  6. Check server performance and health
  7. Check database performance and health
  8. Review and adjust baselines
  9. Validate capacity plan
  10. Submit status report

Take a look at the article for full details and see if you have any recommendations for additional items.

Advertisements

2 thoughts on “10 Monthly Maintenance Tasks For SQL Server”

  1. Ultimately DBAs should do these activities. DBAs who are administering large productions databases encounter a problems and issues dealing with database performance. Large production database administrators use GUI based tools to manage the performance problems. These tools help administrators to identify the root cause. Enteros Upbeat High Load Capture provides these analysis. Information about Enteros High Load Capture can be found on http://www.enteros.com

    Like

  2. Certainly these are tasks that a DBA must do to avoid performance issues. Besides these tasks there are a variety of tools that are gaining reputation in today’s world for managing performance of database. These tools help the DBA to identify and remediate database performance problem. Enteros is one of the companies that is providing tools to proactively respond to the performance problems in productions database. More details can be found on http://www.enteros.com

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.