1. karzon New Member

   hi there,
   I've a SQL server 2005 Enterprise (x64 bit) on windows server 2003 Ent (x64 bit).
   Recently the SQL server run very Slow. From Task Manager I found the sqlservr.exe process usages CPU 80% to 100% . The problem is going on constantly.
   
   What is the cause and how to solve the problem.
   Plz help me.
   
   Thanks
   
   
   
   
   karzon
   karzonr@gmail.com

   karzon, Jun 19, 2007

   #2
2. satya Moderator

   Take help of thishttp://sqlserver-qa.net/blogs/perftune/archive/2007/04/26/high-cpu-spikes-affecting-performance.aspx and alsohttp://sqlserver-qa.net/blogs/perftune/archive/tags/performance/default.aspx for relevant checkout blogs.
   
   Satya SKJ
   Microsoft SQL Server MVP
   Writer, Contributing Editor & Moderator
   http://www.SQL-Server-Performance.Com
   This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

   satya, Jun 20, 2007

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in