VMware Cloud Community
dhchentw
Contributor
Contributor
‎08-16-2011 11:35 PM

vCenter's SQL Server loading question

My vCenter installation uses SQL Server 2008 std as backend database, hosting on a VM(2G mem, 2 vCPU)

Every 10 mins, the cpu usage of the sql server host goes up to 50% for about 2 or 3 sec, then drop to 1%~5%.

I found that vCenter has a batch called calc_topn_past_day comsumes the cpu. Is it normal

for that batch to run such a long time? I think it's just a performance counter counting batch

and that cpu usage triggers vCenter cpu alarms which i'm eager to remove it....

my vCenter manages 4 hosts, total 30 vms. I've done reindexing and deleting transaction log

as kb tells me.

0 Kudos
1 Reply
psyclone1976
Contributor
Contributor
‎08-25-2011 06:23 AM

Have you checked this out?

VMware vCenter 4 Database Performance for Microsoft SQL Server 2008 - http://www.vmware.com/pdf/vsp_4_vcdb_sql2008.pdf

You have also need to reserve some CPU resoruces of the VM and think about creating resource group for this guest so it can get resources as it needs them if this turns out to be default behaviour.

0 Kudos