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
    ismailadar, Jan 12, 2011
    #2

  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.
    Luis Martin, Jan 13, 2011
    #3

  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
    ismailadar, Jan 13, 2011
    #4

  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.
    satya, Jan 13, 2011
    #5

  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
    adityaguthey, Jan 17, 2011
    #6

  6. ismailadar New Member

    thanks for your replies
    ismailadar, Jan 17, 2011
    #7

  7. ghemant Moderator

    ghemant, Jan 17, 2011
    #8

Share This Page