On 19 March 2010 10:05, JD wrote:
> ...

I just now had a host CPU issue that I fixed.
With guest CPU near 0%, the host was showing CPU ~25%

It turned out to be that SqlServer 2005 calling a Windows function to
increase the 'PM' timer resolution to 1ms, which causes VirtualBox to
eat host CPU cycles.

This was visible in the VBox.log as:
00:16:07.848 PIT: mode=2 count=0x4ad (1197) - 996.81 Hz (ch=0)

For SqlServer there are a couple of fixes:
1) Set a SqlServer Startup Options Trace Flag that stops SqlServer
using 1ms timer resolution:
http://social.technet.microsoft.com/Forums/en/windowsserver2008r2virtualization/thread/ec6b08d0-abfd-4e43-8c53-e1cd262fd416

2) Install Cumulative Hotfix 5 or greater, which also stops SqlServer
using 1ms timer resolution:
http://support.microsoft.com/kb/972767/

Similar problems and fixes apply to SqlServer 2008 also.

If other programs are using a 1ms timer, the fix will be different and
program specific.

Mark

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Vbox-users-community mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/vbox-users-community

Reply via email to