Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL 2005 process running at 100% CPU

Posted on 2011-03-09
12
Medium Priority
?
1,314 Views
Last Modified: 2012-05-11
My sqlservr.exe process is running at 100% CPU utilization throughout most of the day... I'm running Windows 2003 Server 32 bit as a VM on a VMWare ESXi host.  I found the below link, however, I'm not sure if I'm running NUMA (non-uniform memory access).  Does this hotfix pertain to me?  The ESXi host hardward is a HP DL 380 G4.

http://support.microsoft.com/kb/931821/en-us

0
Comment
Question by:gopher_49
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
12 Comments
 
LVL 16

Expert Comment

by:Danny McDaniel
ID: 35088355
it doesn't appear that your system is supported by ESXi 4.x and doesn't have the newer Intel processors that are NUMA based, so unless you see the lazywriter behavior described in the MS KB...I would think that it doesn't apply to you and your cause is something else.
0
 

Author Comment

by:gopher_49
ID: 35088698
ok.. I might simply be that I have alot of indexing and/or transactions going on.  It's constantly archiving emails. Once I stop the archiving process (on a different server) it then gets better...  What if I set the priority to the process lower?  Would that help?  Is that suggested?
0
 
LVL 16

Expert Comment

by:Danny McDaniel
ID: 35089109
I'm not a SQL expert so I don't know what the affect would be if you changed the process priority.   You might want to open this question up to the SQL Server zone.
0
Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

 
LVL 24

Expert Comment

by:Luciano Patrão
ID: 35093542
Hi

With this server and this CPU, I think you will get that 100% CPU in any VM that you use that needs CPU processing.

Like danm66, that server is not supported.
This is the same as Dell SC1425 or 1950. It works for some models, but all the VMs have many times with the CPU between 80/100% use.

Jail
0
 

Author Comment

by:gopher_49
ID: 35098479
I ran this VM and this SQL db causing the CPU utlization for months and no problem.  This just recently started a few days ago...  I refreshed the install of the app (the app is on a physical server and saves to the SQL db on the VM) and ever since then I've noticed this.  When using the SQL profiler I'm able to see which aspect of the db is causing the high CPU utilization, however, it's never done this before.

I seriously don't think it's an issue with my procs and/or compatibility for it's never done this in the past.
0
 

Author Comment

by:gopher_49
ID: 35098494
Also,

I have 2 x DL 380 G4's running 7+ VM's and none of the other VM's do this..  And two of them are running the same version of SQL...  I really think it's a software/db issues..  I have the stored procedures that it's choking on.  I might end up contacting the software vendor...
0
 
LVL 16

Expert Comment

by:Danny McDaniel
ID: 35098984
I agree, contacting the s/w vendor sounds like a good next step.  Sounds like there's something out of sync causing the procedure to get hung up.
0
 

Author Comment

by:gopher_49
ID: 35099247
I'll call them and then will update the ticket.  I used the SQL Profiler to determine what exact aspect of the DB is causing the issue.  That should speed things up...  
0
 

Accepted Solution

by:
gopher_49 earned 0 total points
ID: 35215078
It ended up being an issue with my indexes...  Once I rebuilt the SQL indexes the processor performed like it did in the past.  It does spike and sometimes even hangs for awhile when really busy, however, throughout most of the day it's fairly normal... Next year I plan to replace my ESXi hosts with HP g6's dual 4 x core procs...  I'll then void these CPU performance issues.
0
 
LVL 16

Expert Comment

by:Danny McDaniel
ID: 35220362
How many vcpu's do you have assigned to the vm in question and how much RAM?
0
 

Expert Comment

by:SBPGOIT
ID: 36013217
gopher_49 how were you able to see that in the profiler?
0

Featured Post

Building an interactive eFuture classroom

Watch and learn how ATEN provided a total control system solution including seamless switching matrix switch, HDBaseT extenders, PDU, lighting control to build an interactive eFuture classroom.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question