• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 637
  • 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 HavireAuthor 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
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
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 HavireAuthor 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 HavireAuthor 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

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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