September 9, 2009 at 4:10 am
Hi Guys,
This question is more related to hardware than SQL Server. What would be the advantages of having SQL server on a physical machine as to having it on a Virtual machine.
Can you perhaps give examples with your explanations?
Regards
IC
September 9, 2009 at 4:20 am
Imke Cronje (9/9/2009)
Hi Guys,This question is more related to hardware than SQL Server. What would be the advantages of having SQL server on a physical machine as to having it on a Virtual machine.
Can you perhaps give examples with your explanations?
Regards
IC
It does depend on what version of sql server you are going to use. and what version of windows. also if you are going to use VMware or the likes of hyper v.
I personally have never seen a virtual sql sql server production box, although others on this forum have. I have only seen virtual sql servers in dev and test environments.
I would prefer to have physical boxes, and I have worked with virtual sql servers for most of the roles i have had recently.
But i have seen virtual sql servers crashing very easily.
Normally a VM machine has to be more powerful that the physical equivalent, down to limitations due to VM software and what it can handle.
I can recommend having sql server virtualised, but only for specific uses and not for mission critical high transactional databases.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 9, 2009 at 4:24 am
It depends! Lots of variables in your question.
We do use VM for some SQL Server databases but they are low in load. It was a consolidation exercise to move smaller and less used databases away from the main servers. I think VM's are fine for this. We've had no problems with VM at all for the database servers - Some of our application servers, on the other hand, have been problematic.
If its a big, intensive, resource hungry, critical database then go physical..
September 9, 2009 at 4:27 am
Thanks for your input.
We are running on Windows Server 2003 and SQL Server 2005.
Do you perhaps know of any articles about this topic?
September 9, 2009 at 4:32 am
Quick google search on sql server virtualization would be a good start.
I also have a pdf which I can send over if you drop me an email address...
September 9, 2009 at 4:41 am
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply