vCenter sql server using 100 % cpu

[geekinlinux]

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.

[ecsysadmin]

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?

[JLackman]

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.

[akkayyakapisett]

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

http://www.peeradmin.com