SQL Server Performance

High Cpu usage

Discussion in 'SQL Server 2008 General DBA Questions' started by ismailadar, Jan 12, 2011.

  1. ismailadar New Member

    hi All,
    I wonder that when sql server cpu reaches 100% which steps are taken indor to identify problem?
    for example you should firstly profil sql server?
    and any idea?
    thanks in advance
  2. Luis Martin Moderator

    Yes with profile you can find queries using high CPU.
    Now, what OS, SQL and SP do you have?
    Also memory configuration.
  3. ismailadar New Member

    is there anything for checking except for Profiller. For example master.dbo.sysprocesses table should be checked.
    SQL server 2008 enterprise ed sp 1 on windows server 2008
  4. satya Moderator

    Why not use Activity Monitor to see what are the expensive queries and processes running at that point of time?
    Also you can make best use of Management Data warehouse feature in SQL SErver 2008 as you are using correct version to support.
  5. adityaguthey New Member

    It might be due to costly queries, you can also use the query select spid, hostname, program_name, loginame, cpu, last_batch, db_name(dbid), cmd
    from master.dbo.sysprocesses and do a dbcc inputbuffer(spid) to find out the query which is taking the most amount of time
  6. ismailadar New Member

    thanks for your replies
  7. ghemant Moderator

Share This Page