Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 virtual server question

Author  Topic 

helpme
Posting Yak Master

141 Posts

Posted - 2009-08-28 : 12:15:32
I read the post listed below (from a couple of years ago) about virtual servers and it sounded like the thought was that they were best used for development and testing environments and shouldn't really be used for heavily used production systems. I was just curious if this was still the general concensus among folks who have worked with them. I didn't know if newer technologies might have aleviated the performance issues or not.



http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78101&SearchTerms=virtual,server,test

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-30 : 09:18:18
We run production SQL Servers in a virtual environment. Had several performance/stability issues early on. But after we got the resource allocation properly aligned, everything runs fine. So, be sure to ring-fence the disks, group servers according to usage, etc. Also check on the backup plan - had several issues with snapshots filling up the disks. But again it's a learning/operational issue. The technology is fine.

We only use it for second tier production systems (the mission critical systems run on physical clusters).
And having it on VMs also simplifies the DR strategy.
Go to Top of Page

helpme
Posting Yak Master

141 Posts

Posted - 2009-08-31 : 07:28:09
Thanks YellowBug
Go to Top of Page
   

- Advertisement -