It's really going to depend on the hardware you have and how taxed it is... I've heard of folks running SQL in VM's that were heavy processor and I/O hitters, they did fine... Like any VM implementation, you need to benchmark it in a physical environment and determine if a virtual environment is right for that particular server...
On Jan 23, 2008 11:38 AM, Ara Avvali <[EMAIL PROTECTED]> wrote: > > Hi > > Thanks for everyone responding. Yes performance is the major point. As > example if it is going to be a lot slower to run query in VM compared to > host. > > > ------------------------------ > > *From:* Don Ely [mailto:[EMAIL PROTECTED] > *Sent:* January 23, 2008 2:12 PM > *To:* NT System Admin Issues > *Subject:* Re: Virtual Server 2005 > > > > > Not visible to the VM itself, no. It all happens on the physical host... > So yes, you can run SQL in a VM on VS. I've heard varying results when > doing so. Mostly depends on how much processing occurs overall on the > phsyical host... > > On Jan 23, 2008 11:09 AM, Barsodi.John <[EMAIL PROTECTED]> wrote: > > > > Sorry I'm dumb, but I don't use GoExchange. ;) > > > > You're point is valid. However, it doesn't allow for multiple threads > actually in the VM, correct? I think or assumed that's what he was looking > for when he referenced SQL performance. > > > > > > > > *From:* Don Ely [mailto:[EMAIL PROTECTED] > *Sent:* Wednesday, January 23, 2008 10:50 AM > > > *To:* NT System Admin Issues > > *Subject:* Re: Virtual Server 2005 > > > > > Not entirely correct... VS 2005 only allows one configured processor per > VM. VS 2005 load balances process requests across all of the > physical/logical processors on the host... > > On Jan 23, 2008 10:43 AM, Barsodi.John <[EMAIL PROTECTED]> wrote: > > > > "Does this mean a guest server can only take advantage of a single > processor which is massive performance decrease?" > > Correct, VMware server allows SMP > > > > *From:* Ara Avvali [mailto:[EMAIL PROTECTED] > *Sent:* Wednesday, January 23, 2008 10:42 AM > *To:* NT System Admin Issues > *Subject:* Virtual Server 2005 > > > > > > Hello everyone, > > > > I want to be clear on something so I ask! Google gives a lot of different > results. > > We have a server which has dual processors with quad core. So when I run > the task manager on host it shows me 8 logical processors. I installed > virtual server 2005 on it and ran another server 2003 inside it. Internally > task manager shows only one logical processor. > > > > Does this mean a guest server can only take advantage of a single > processor which is massive performance decrease? Or does it see the 8 > logical core combined as one processors so it is the same speed of host but > only different look? > > > > It is a debate if SQL Server 2005 should be running in VM or not. > > > > Thanks > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
