SQL Server Performance

sqlservr.exe usages 100% CPU

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' 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. techbabu303 New Member

    If you have less than 1000 batch/sec request on this server then you run SQL profiler trace with RPC start and RPC complete enabled during this peaks and then check the trace file to indetify the causing it.

    Also check perfmon for signs sql compilations/sec.

    Cheers
    Sat
  3. techbabu303 New Member

  4. satya Moderator

Share This Page