Solved

sqlservr.exe 100 percent cpu utilization

Posted on 2013-01-25
4
1,260 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now