Solved

sqlservr.exe 100 percent cpu utilization

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help Required 3 108
SQL Server - Set Field Values ito Zero Based on Related Table 4 40
sql 2008 how to table join 2 27
union query column need default text 2 15
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Learn about cloud computing and its benefits for small business owners.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

840 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