VMware Cloud Community
wb2
Contributor
Contributor
‎05-08-2014 07:39 AM

cpu at 100% every 10 seconds or so

I have MS SQL2008 R2 server on VMware esx5.1.  In the last couple of weeks we've had to restart the server because of poor performance.  There are time outs,etc..  In Windows (2008R2), CPU will show 100%, short spikes every 10 seconds.  Has anyone seen this?  From VMware Vcenter gui, lan/nic looks fine. 

Reply
0 Kudos
2 Replies
Alim786
Expert
Expert
‎05-08-2014 08:16 AM

Normally SQL Server is disk I/O intensive. How have you configured the storage ? Is it using dedicated LUNs/Datastores for DB and Logs ? Is it using Fast Disks ?

VCP6-DCV, VCP5, CCNA, MCTS 2008R2, MCSA 2008R2, CCA, ITIL. Please mark answer helpful or correct as appropriate.
Reply
0 Kudos
King_Robert
Hot Shot
Hot Shot
‎05-09-2014 03:40 AM

we need to confirm first that the issue with VMware or Windows itself ..check which of windows services is taking much CPU.Also check your VMware tools should be installed properly on VM

Thanks

Reply
0 Kudos