SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Running a production SQL environment on a virtual server


Running a production SQL environment on a virtual server

Author
Message
Yvan Bouchard
Yvan Bouchard
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1174 Visits: 394
Hi to everyone,

In order to reduce costs, we are looking at setting up some virtual servers. As the concept if pretty clear to us, the technical side is still new to us, so I was looking to find out if any of you had some thoughts on what to look-out for when putting a production SQL Server out on this kind of set-up.

Thanks

Yvan
Kenneth Fisher
Kenneth Fisher
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6125 Visits: 2058
I've used virtual machines with SQL Server at my last 2 jobs and its worked fairly well. The only thing I can think of off the top of my head is that if they are going to make any changes to the virtual environment .. particularly disk space .. shut down your SQL Server while they do it.

We increased disk space without shutting down SQL and completly corrupted our databases.

The only other problem I've seen was a snapshot that got out of hand. It kept updating itself and using up more and more space. Even though we had told it it was a one time snapshot. We found out about it when it eventually used up a terabyte drive. Not entirly sure what caused it though because our server team handled it.

Kenneth

Kenneth FisherI strive to live in a world where a chicken can cross the road without being questioned about its motives.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/Link to my Blog Post --> www.SQLStudies.com
KenpoDBA
KenpoDBA
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2352 Visits: 634
Y, I've run it a couple times too. Though I wouldn't use it for anything with really high transactions, it worked really well for our lesser sql boxes.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:


Yvan Bouchard
Yvan Bouchard
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1174 Visits: 394
Kenneth,

Thanks for the info, we'll keep it in mind

crever,

Thanks
Kenneth Fisher
Kenneth Fisher
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6125 Visits: 2058
True. I've only ever used it on development and test boxes.

It was very nice though when using for test boxes because you could put up a new test box in a matter of minutes. Or set up for a series of tests, do a snapshot, run the tests and then restore the snapshot for the next set of tests.

Kenneth FisherI strive to live in a world where a chicken can cross the road without being questioned about its motives.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/Link to my Blog Post --> www.SQLStudies.com
alen teplitsky
alen teplitsky
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6678 Visits: 4674
when we bought VMWare a few years ago the sales guys specifically said don't run SQL or Exchange on it

your best bet in reducing expenses is buying x64 hardware and scaling up
Yvan Bouchard
Yvan Bouchard
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1174 Visits: 394
SQL Noob,

We will double-check on that. We have contradicting information on this. I do not know our info is coming from the sales guy or a technical guy!Unsure

Which version are you running?

Y
KenpoDBA
KenpoDBA
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2352 Visits: 634
Well, that was a few yrs ago. MS if embracing virtual environments with SQL these days.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:


Kenneth Fisher
Kenneth Fisher
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6125 Visits: 2058
Actually I read an article that said that Microsoft will even provide support for using SQL with VMWare .. as long as the VMWare is their version of it Smile.

Kenneth FisherI strive to live in a world where a chicken can cross the road without being questioned about its motives.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/Link to my Blog Post --> www.SQLStudies.com
Joe Clifford
Joe Clifford
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2033 Visits: 619
If your experience with VMWare was a few years ago, things have changed pretty dramatically with the introduction of the hypervisor in the current versions of VMWare (MS will be releasing theirs shortly).

Virtualization is suitable for production use as long as you've got all of your ducks in a row and understand the pro's/con's of the technology.

Virtualization is really all about the underlying infrastructure, done right virtualization works well, done wrong/cheaply it usually fails miserably. Probably the most important thing I've seen is that virtualization tends to place a lot of demands on the underlying storage layer which many SAN's/NAS's & fabrics/networks just aren't ready for. Also be prepared to see your storage needs skyrocket, as noted it becomes pretty easy to "spin up" new instances for A, B, C, D... definitely something you need to plan for.

Joe



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search