x

vmware consolidation

Is it a good practice to consolidate databases that are currently running on different virtual guest machines to one virtual server to save licensing cost and administration? What would be a recommended approach?
more ▼

asked Jan 24, 2012 at 03:40 PM in Default

ebzm gravatar image

ebzm
423 29 33 35

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Yes, virtual servers can result in huge cost savings. But it would depend upon your environment how much that would be.

Microsoft allow you to run as many virtual instances of Microsoft SQL 2008 on the same server that you bought a license of the product for. So the more Microsoft SQL instance you need that can run on the same physical server the more money you can save. The CORE benefits are

You will Save Space, Hardware, Power and Its not just about saving, but you get a lot of extra protection and availability

An inherent benefit of VMware virtualization is that it facilitates a distributed computing model in multi-server environments, such as those that may include a database server, an application server, and a web server.

Using the virtualization features that you can manage the resources that support these systems as a pool, rather than as individual components. Live migration of virtual machines from one physical server to another is possible, with no effect on the running applications.

VMware High Availability (HA) clusters provide continuous service availability in both planned and unplanned system downtime situations.

Distributed Resource Scheduler (DRS) dynamically load balances all of the VMware virtual machines across the entire pool of available resources.

VMware Consolidated Backup offers a simplified virtual machine backup solution.

So there are quite a few benefits but the implementation is quite complex and may not give you the optimal performance if not configured correctly.
more ▼

answered Jan 24, 2012 at 10:26 PM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

(comments are locked)
10|1200 characters needed characters left

I agree with @usman, but I want to add the performance aspect. Not every database is suited for consolidation, like your business critical database that require ultimate performance. Sharing resources often means that you can't get all resources you need, when you need it because you have to share. That's the concept of shared resources.

To find out if you are going to handle the database load you could do a benchmark test like the one described at http://sqlservice.se/sql-server/sql-server-performance/a-sql-azure-tip-a-day-17-my-laptop-is-faster-than-sql-azure/

With a benchmark test you can compare different configurations and choose the best for you, your application and your budget. You'll get what you pay for.
more ▼

answered Jan 24, 2012 at 11:24 PM

Håkan Winther gravatar image

Håkan Winther
15.6k 35 37 48

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1841

asked: Jan 24, 2012 at 03:40 PM

Seen: 594 times

Last Updated: Jan 24, 2012 at 03:40 PM