News & Events

Microsoft SQL Server consolidation strategy

Reliability and performance are the two main concerns for database administrators, especially those working with large databases that are under continuous heavy load. Virtualization can play a big role in improving reliability for your datacenter. Have you considered database server consolidation?

SQL server consolidation is something that many SQL server support DBAs and SQL Server consultants shy away from because of the perception that it is too difficult. There was a time when this was true, but modern SQL server installations offer much better consolidation options, and there are many benefits to consolidation.

Consolidation involves exactly what the name suggests – consolidating your servers. Instead of having separate physical servers for each project – with their own hardware, databases and software, and their own individual support and maintenance overheads, you merge your solutions onto fewer machines.

The separate solutions approach leads to “islands” in your datacenter. You may think this is a good thing – if one server goes down, others won’t go down with it. However, if your servers are interdependent then you’ll still suffer if one server fails. In addition, having multiple machines, each needing OS, server and software patches, security monitoring, backup solutions, and other maintenance work, is a waste of resources. Consolidating your servers reduces the maintenance overhead massively. It could also save you a lot of money in “per seat” licensing fees.

Why now is a good time to consolidate
Now is a good time to start looking at SQL server consolidation. Microsoft will be ending SQL server support for Microsoft SQL Server 2008 R2 in Q2 2014. If you are running that version, or an older and currently unsupported version of SQL server, you should seriously consider upgrading soon.

Newer versions of Microsoft SQL Server offer many performance improvements, even on relatively old hardware. With consolidation, you can enjoy:

Better use of your existing hardware – no more servers sitting at only 10% CPU utilization for most of the day.

Improved scalability – it’s easier to move a VM from one machine to another than it is to completely rebuild a physical computer.

Easier backup and recovery – take snapshots of your VMs periodically, and you can re-load them easily to get up and running instantly. Reinstalling a traditional OS (or even re-imaging a drive) takes far longer by comparison.

Rapid provisioning – you can deploy new virtual servers on demand.

Consolidation isn’t a magical fix
If you are considering consolidating your SQL servers, you should bear the following in mind:

Performance can be bottle-necked by the speed of your drives in environments with heavy I/O. Consider using SSDs to get around this issue.

The virtual environment you use may limit performance.

The technology is still immature – test your virtual servers thoroughly for unexpected driver/performance issues before putting them into a production environment.

Consolidating your servers is a good way to reduce waste and improve performance and reliability if you have several standalone servers which generally experience only light or medium load. Tread carefully when considering consolidating servers that are heavily utilized, and make sure that you do not overload the physical machine that is hosting the VMs.

Get in touch

For more information or to schedule a demo please contact us

Contact us


dsp drives up its share of the Database MSP Market with
record contract growth and 2nd acquisition

DSP firmly established itself as one of the UK’s fastest growing proactive Database MSPs during 2016, signing £2.1m of new contracts and making its second acquisition, the Oracle DBA support division of IT Services provider ITSB.

Read more
View All


Applications on Oracle Database Appliance (ODA)

A main goal... how to future proof your applications environment through Oracle while becoming more efficient in terms of costs and productivity.

As well as the option of developing the fundamental steps you need to take to get ...

Read more
View All


How can you regularly benchmark your database and application infrastructure against real-life? Why would you want to?

In the age of big data, public cloud, private cloud it’s easy to be pushed into constantly thinking about the future... What should you optimise though and how can you be sure it’ll make a difference? Would knowing it could give you a competitive edge be worth considering?

Read more
View All