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> ~
