• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 642
  • Last Modified:

90% CPU utilization on SQL Server 2008

Hi Experts,

I have an application  which is made in .net and it's running under IIS 7 on Windows 2008 Server. I have 16 GB memory on Server, and we have SQL 2008 R2 is DATA BASE, I see always 90% + CPU utilization for SQL Server when in running state and Application running EXTREMELY slow on the Server.

Can anyone Help me, Thanks in Advance
0
Nilesh Havire
Asked:
Nilesh Havire
  • 4
  • 3
2 Solutions
 
Jared_SCommented:
Run "exec sp_who2" on your sql server and check out the details of the SPIDS that are taxing your system so much.

After that, hopefully you'll have an idea of where to look in your application.
Review your code for inefficient queries and/or connections that aren't being closed properly.
0
 
mastooCommented:
Is the same server hosting the web service and the database server?  If so, you might start by figuring out it the cpu is being used by sql server or IIS or possibly something else.  Use task manager or resource monitor to look at cpu utilization by process on the server.
0
 
Nilesh HavireBusiness ITAuthor Commented:
We have hosted DB and Application on Different Server, Both in Same LAN Speed between both server is 1 GBPS, we have 4 GB RAM on Application Server,  there no issue about Memory usage, but we have 16 GB RAM on DB Server we are facing Mem & High CPU usage on DB Server, I have checked in Task Manager all CPU eat by SQL Server

DB:-192.168.0.11
Application:- 192.168.0.12
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
mastooCommented:
The high memory usage can be normal, with Sql taking full advantage of memory for caching.  Before we try to identify the process within sql that is using the cpu...

This is a multi-processor system I assume, and you're saying it is averaging 90% on total cpus?
Was it working fine before of is this new, in which case has something been updated?
And, do you have a maintenance plan that updates indexes / statistics?  Lack of this is probably the most common cause for high cpu.
0
 
Nilesh HavireBusiness ITAuthor Commented:
Hi Mastoo,

It's new Server we are facing this issue from beginning, and I cant get downtime, I'm not getting How to start troubleshoot ?
0
 
mastooCommented:
This is an application that was in place and working fine, then you replaced the database server and now it runs too slow?
0
 
Nilesh HavireBusiness ITAuthor Commented:
We have deployed this Application first time and this is the first server
0
 
mastooCommented:
I better drop out of this thread then due to the scope of diagnosiing a performance problem like this on a new system.  It could be anything from a hardware problem, an undersized server or i/o system, a database problem, or an application design problem.  Hopefully somebody else will jump in or you might look for assistance from the application's developer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now