SQL Server Takeover

Imagine this … you have just been given the responsibility to manage another SQL Server that you know nothing about …

Ok, maybe we don’t really have to use our imagination in this scenario, since this happens all the time to DBA’s. For example, perhaps you have started a new job (which was recently my case) … or maybe your company acquired another company and its IT resources … or possibly there was a SQL Server instance under someone’s desk that now IT has to take care of.

What should a DBA do in those situations? Well, in this post, I am going to try to explain some of the first steps that I normally do when I take over a SQL Server.

Check for proper database maintenance running

  • Maintenance plans or solution – Determine if there is a comprehensive strategy to handle the database maintenance. This could be a set of maintenance plans or something like Ola Hallengren’s maintenance solution (https://ola.hallengren.com/). Whatever the case, it should include backups (see previous point), indexing optimizations, integrity checks, and cleanup (database and server).

Check for some standard configurations on the databases

Check for some standard configurations on the SQL Server instance

Well, these are some of the basic first steps I take when I inherit a SQL Server. Of course, more tuning and adjustments will need to be made as you come to understand the load and usage of the server. But, this is just a start.

This entry was posted in DBA and tagged , , . Bookmark the permalink.

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