Solved

sqlservr.exe 100 percent cpu utilization

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
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.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

770 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