SQL Server Consolidation Challenges!

The estimated reading time for this post is 1 minutes

What is SQL Server Consolidation? You can simply assume that SQL Server databases in different instances from different servers come and reside together at one high performance server hardware.

Early during consolidation project, we always need to find some answers for some questions by assessment such as

  • What is the resource usage per SQL Server instance?
  • What is the overall performance of the server?
  • When is the peak hours for SQL Server?
  • Do we need to keep all databases in one hardware?
  • Do we need to upgrade databases as well?
  • Do we need to change application codes?
  • Do we need to use virtualization?
  • Do we need to architecture base on databases or instances?

And a lot more questions. Any mistake in this early stage can cause project to fail.

After all those questions answered by assessment result, the next step is to implement and kick off the project. In this stage we always face some difficulties, for example during consolidation some of the databases are in need to be up all the time! or the security credentials need to be migrate without any changes! And also the migration time is limited!

In the last stage of consolidation project, you will face some challenges such as database performance, security hardening, high availability, disaster recovery and in some cases OLAP performance degradation, which needs to be settled otherwise the consolidation project is considered fail project.

At glance looks simple, but it is damn complicated.

Hamid J. Fard

I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. I also do Pig, Hive and Sqoop development regarding Hadoop Big Data platform. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.

More Posts

Follow Me:

Leave a Comment

Notify of