Hi,
We have an issue currently where our Microsoft SQL server runs close
to 100% CPU for a lot of the time. There also seems to be a lack of
memory cache hits (we would expect a reasonable amount given the
traffic for our site).
Our website generates a lot of small queries (approximately 200odd
I would say it is from running it on VMWare. I have never had good
experiences running SQL server on VMWare. There just isn't the grunt there
to do it. I started shifting my SQL servers to VMs and started having CPU
issues so i moved them back to physical servers.
-Original Message-
What Steve says is def. contributing to it.
Another thing I'd look into before moving it away from VMWare though would be
the VMWare setup itself, e.g. assigned memory, giving it more CPU power etc.
How's your disk IO looking on that VM?
Cheers
Kai
On 24/11/2010, at 11:48 AM, Steve Onnis
We're running SQL Server 2005 quad core on VMWare, and it works fine without
any problems.
On 24 November 2010 09:48, Steve Onnis st...@cfcentral.com.au wrote:
I would say it is from running it on VMWare. I have never had good
experiences running SQL server on VMWare. There just isn't the
On 24/11/2010 09:53, Kai Koenig wrote:
What Steve says is def. contributing to it.
Another thing I'd look into before moving it away from VMWare though would be
the VMWare setup itself, e.g. assigned memory, giving it more CPU power etc.
How's your disk IO looking on that VM?
We use SQL2008