Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Virtualization and Preparation Expand / Collapse
Author
Message
Posted Saturday, October 24, 2009 12:49 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 18, 2014 4:04 AM
Points: 176, Visits: 567
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
Posted Monday, October 26, 2009 5:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:04 AM
Points: 2,728, Visits: 1,116
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
Posted Monday, October 26, 2009 7:20 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
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
Posted Monday, October 26, 2009 7:22 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Posted Monday, October 26, 2009 11:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC 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
Posted Monday, October 26, 2009 3:25 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
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
Posted Tuesday, October 27, 2009 3:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:04 AM
Points: 2,728, Visits: 1,116
Steve Jones - Editor (10/26/2009)
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.


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
Posted Tuesday, October 27, 2009 7:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
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 »

Add to briefcase

Permissions Expand / Collapse