Solved

sqlservr.exe 100 percent cpu utilization

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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

627 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