Virtualization and Preparation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » Virtualization and Preparation

Virtualization and Preparation

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Saturday, October 24, 2009 12:49 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:54 PM
Points: 31,410, Visits: 13,726

Comments posted to this topic are about the item Virtualization and Preparation

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #808330

Posted Sunday, October 25, 2009 11:05 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 11, 2013 12:58 AM
Points: 174, Visits: 555

This post was good one! I have finished making an inital DRP using virtualization. It's great but I could use a newer, more powerful server instead of adding RAM and re-using an old server.

I can rest easy instead of relying on tape backup (what if the entire server goes down), I just make a script to copy the complete DB backup. (I know it's a long story regarding checking backups etc. so let's skip that since ). Then the DB backup is restored on the VM if things go down.

Post #808487

Silverfox

Posted Monday, October 26, 2009 5:23 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:50 AM
Points: 2,719, Visits: 1,065

Nice article, good valid points and the links are interesting, still dont agree with virtualisation as the preferred solution for consolidation. I dont necesary agree with some of the points raised as well, I am yet to see a successful implementation at a client.

Always better to be prepared in any case. would be nice if MS included some sort of automatic DR creation even if you had the ability to turn it off, still would be nice to have.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw

Post #808592

Steve Jones - SSC Editor

Posted Monday, October 26, 2009 7:20 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:54 PM
Points: 31,410, Visits: 13,726

I don't think I said that virtualization is the preferred method for consolidation. I am pro-virtualization, and it's worth considering. As I mentioned, it's not for everyone or every instance.

But I think dismissing it out of hand is a mistake as well.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #808670

GSquared

Posted Monday, October 26, 2009 7:22 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

A disaster is an emergency you haven't prepared for.

I like the linked blog post. Flat spare tire = untested backup (or similar) is a good metaphore.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #808673

sjsubscribe

Posted Monday, October 26, 2009 11:20 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, December 20, 2012 1:03 PM
Points: 265, Visits: 589

Good points about virtualization.

Any complex org will have a variety of db needs, many of which can start on a virtual server and then migrate to a dedicated one as the app grows. Virtualization offers fast setup times and lower cost of false starts. When the setup, backup, and other maint routines can be automated, then virtualization certainly pays off. Seems like the reluctance comes from the undue burden placed on DBAs for managing virtual setups. Some of the automated tools, like those in Solaris, for containers and virtual boxes, certainly ease such concerns. Don't know if MS equivalents are just as useful.

Post #808868

Steve Jones - SSC Editor

Posted Monday, October 26, 2009 3:25 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:54 PM
Points: 31,410, Visits: 13,726

Note that I'm not recommending Hyper-V. I'm not sure it's any better, or any worse, than other software. I have seen VMware used heavily, and it seems to work well for servers. I know some non-Windows folks that like Virtual Box as well, and many Windows people recommend Hyper-V.

You need to perform the due diligence to see which one works for you.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #809005

Silverfox

Posted Tuesday, October 27, 2009 3:09 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:50 AM
Points: 2,719, Visits: 1,065

Steve Jones - Editor (10/26/2009)

We have VMware esx where I am atm, we have had problems with performance and the vmhost going down at times. even the VMware specialist here doesnt recommend sql being on vmware.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw

Post #809147

Steve Jones - SSC Editor

Posted Tuesday, October 27, 2009 7:13 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:54 PM
Points: 31,410, Visits: 13,726

You might not have the right SQL Servers on your ESX system, or it might not be sized. I know of 4 companies in the Denver area that run it and have done so for over a year. They are thrilled with the way it works in that they can save on hardware, but more importantly, space and cooling. However many of their larger SQL Servers, for things like ERP, have not been moved. The performance, and the scale is not there.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #809277

« Prev Topic | Next Topic »

Permissions