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

Generally, SQL installations on VMware aresimilar to that performed as they would be on physical hosts with additional optimisation performed on VMware.

I have been running SQL sever VMware since 2002 and even with the obvious benefits listed above performance has been my biggest gripe. The fact that processors, storage and its connections are generally shared means that I have kept the most demanding servers on separate high powered machines. That said, a lot of servers can be fully provisioned on high spec equipment running ESX.

There are some important areas to understand when considering moving onto VMware, chief among these are CPU, memory and disks.

For the purposes of this discussion I will be looking at the option available with VMWare's ESX server which I believe is the only viable option for a production SQL server

CPU
CPU virtualisation adds varying amounts of overhead, depending on a number of different factors. For processor-intensive applications like SQL server the CPU overhead of virtualisation is likely to result in a reduction in overall performance. However, this is mitigated to some degree by the efficient manner in which VMware balances processor loads and virtual machines running on VMware can leverage multi- cores and multi-processor configurations, making it possible to run processor-intensive workloads. VMware allows you to assign different virtual CPUs to your virtual servers.

Memory
Memory if the most common factor limiting the number of virtual machines you can run on a single physical machine IT does not reduce the memory demands of SQL or the windows operations system. VMware however, has limited memory overhead and its RAM over commitment allows better memory allocation and utilisation. IT can dynamically increase or reduce the amount of RAM assigned to a virtual machine as the application demands increase or reduce. This allows higher severe consolidation than is possible with static virtual memory.

Disks
VMware machines run complete operating systems and the stiorage requirements of SQL server need to be taken into consideration when deciding to move to a VMware infrastructure. SQL server is a I/O intensive application and the impact on disk I/O of simultaneous disk access by multiple virtual machines consolidated on a single physical server can result in performance degradation. VMware goes someway to improving I/O performance through VMFS. Centralised storage helps reduce latency and increase throughput

Disk Configuration Options
You can configure virtual machines with multiple virtual SCSI drives which appear to the virtual machine as a SCSI device attached to a SCSI adapter.


Share:

More from Techworld

More relevant IT news

Comments

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

* *