Follow Us

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message

How to virtualise SQL Server

Ways to prepare for a virtualised environment

Article comments

With VMware becoming more common place in the work place, many organisations are still reluctant to deploy production SQL servers on VMware infrastructure. This has been understandable  in the past but VMware environments are now more robust and should be able to handle SQL Server.

It's worth taking the plunge; there are some very good reasons to move some of your SQL servers onto a virtual infrastructure.

Server consolidation
Probably the biggest selling point of virtualisation is the ability it provides to consolidate mission-critical applications and infrastructure services onto fewer highly scalable, highly reliable enterprise-class servers with organisations able to achieve up to 60-80 percent server utilisation thus reducing TCO across their IT infrastructure.

Simplified system management
VMware allows organisations to provision new applications and respond to system change requests in minutes not days and conduct zero-downtime hardware maintenance without waiting for maintenance windows. Its dynamic load balancing capability allows for improved flexibility and responsiveness.
Higher Availability and improved service levels.

Being able to precisely control system resources granted to virtual machines and run them across multiple processors with Virtual SMP (optional) means that resource intensive workloads like SQL server can be run on multiprocessor virtual machines. Low-cost virtual machine clusters providing hardware and software fault tolerance can be deployed on physical clustered systems protecting critical data.

Lower Cost of Disaster Recovery Capability
Using VMware organisations can create a unified disaster recovery platform using ESX Server virtual machines as standby servers. A single x86 system can host multiple disaster recovery virtual machines maintained in a hot or cold state. Stream lining disaster recovery management, increasing availability, reducing recovery time and lowering hardware and operational costs by reducing the need for one-to-one mapping of production and disaster recovery servers.


More from Techworld

More relevant IT news


Tobe said: Nice article dadi like the exploration of the virtualised environment

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story, and in case of transmission error. Both your name and the recipient's name and address will not be used for any other purpose.

Techworld White Papers

Choose – and Choose Wisely – the Right MSP for Your SMB

End users need a technology partner that provides transparency, enables productivity, delivers...

Download Whitepaper

10 Effective Habits of Indispensable IT Departments

It’s no secret that responsibilities are growing while budgets continue to shrink. Download this...

Download Whitepaper

Gartner Magic Quadrant for Enterprise Information Archiving

Enterprise information archiving is contributing to organisational needs for e-discovery and...

Download Whitepaper

Advancing the state of virtualised backups

Dell Software’s vRanger is a veteran of the virtualisation specific backup market. It was the...

Download Whitepaper

Techworld UK - Technology - Business

Innovation, productivity, agility and profit

Watch this on demand webinar which explores IT innovation, managed print services and business agility.

Techworld Mobile Site

Access Techworld's content on the move

Get the latest news, product reviews and downloads on your mobile device with Techworld's mobile site.

Find out more...

From Wow to How : Making mobile and cloud work for you

On demand Biztech Briefing - Learn how to effectively deliver mobile work styles and cloud services together.

Watch now...

Site Map

* *