SQL Server Performance

sqlservr.exe usages 100% CPU

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by karzon, Jun 19, 2007.

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

Share This Page