Solved

sqlservr.exe 100 percent cpu utilization

Posted on 2013-01-25
4
1,288 Views
Last Modified: 2013-01-28
hello I have a 2003 windows server box with SQL 2008 installed. Ironically i have a similar setup implemented in 5 other sites. There are only 4 databases...about 3 Gigs of ram..which is about the same as the other sql servers. But only this one in particular has the problem?

How can i go about finding what exactly is causing sqlservr.exe to resource intensive?

T
0
Comment
Question by:tobe1424
[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
4 Comments
 
LVL 23

Expert Comment

by:Suliman Abu Kharroub
ID: 38820714
IT could be the number of clients and queries no this server is higher than others.
0
 

Author Comment

by:tobe1424
ID: 38820724
but wow its 24/7 pinned at 100 percent. All other, even slightly larger sites don't have this issue.

Is there a way of telling what exactly can be causing sqlservr.exe to use 100 cpu ?
0
 
LVL 35

Expert Comment

by:David Todd
ID: 38823479
Hi,

Dumb question, but when was the last time this server was rebooted, and can you schedule a reboot fairly quickly?

What does sp_who2 indicate?

There is a process I started down for finding which SQL SID is using which OS process/thread, but for me a reboot fixed it, as I couldn't see the SQL that was supposedly so busy.

I was looking to do this:
http://www.mssqltips.com/tipprint.asp?tip=2454

HTH
  David
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 38824387
You could try installing and running Adam Machanic's sp_whoisactive script:
http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx

This will tell you what query is running and how much CPU it is using.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Automate Windows Updates with SCCM 2 127
Can I skip a node in XML? 9 46
SQL Server Express or Standard? 5 63
Need more granular date groupings 4 44
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 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