Hi,
I'm running vCenter 4.1 with around 4 hosts everything fine, for last two days vCenter is showing 100 % cpu usage in taskmanager, i found the process was sql server. i didn't make any changes to vCenter. DRS is enabled on the hosts, all the three hosts showing 50 % load distributed equally. I don't understand why the sql server is using 100 % cpu.
sql server version is mssql 2005 express. not complete installation.
please help me.
thank you very much in advace.
We use vCenter 4.1 with MS SQL 2008 R2.
SQL server started use too much RAM and crashed after I start vCenter service.
I moved database to fresh SQL-server installation (on other VM with 4 vCPU and 10GB RAM).
After I start vCenter process, my SQL server use 100% CPU. Should I do smth or this problem will be fixed automatically after some time?
This is most likely a SQL issue or SQL configuration issue. There are countless SQL issues and mis-configurations that can cause 100% CPU use. Poorly written code, reports, or queries can all do this. I belive you need to start by investigating what is generating all of the activity.
On the VMware side, I'd suggest starting with this link (without knowing more about the situation);
http://kb.vmware.com/kb/2034127
Here are some useful links to help track down specifically what is causing the abuse;
1) How to find out how much CPU a SQL Server process is really using
2) sql server - CPU utilization by database? - Stack Overflow
And here is a great paper from Microsoft for SWL 2008 on using Resource Governor to control performance;
http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/ResourceGov.docx
Without some research identifying exactly what is causing the load, I think it's premature to point at vSphere as a culprit.
SQL express means - It is vCenter simple instllation.
It wont support more than 4 hosts
Check the DISK IO on the VM as DB and vCenter are on the same box, Move the disks to high end storage
Limit the memory of SQL DB using SQL management studio
Venkat