Post reply

Current activity in Enterprise Manager

  • July 23, 2004 at 2:15 am

    #112093

    I have issues with a couple of my SQL2000 servers peaking at strange times.  When looking in Enterprise Manager I have a look at the current processes and I'm not sure what I should be looking at to see what is making the CPU sit at 100% for an extensive period of time.

    Can you please tell me what I should be looked at to see what process is causing my server to come to a screaming holt

    Thanks in advance

    Thanks,

    Kris

  • July 26, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • July 26, 2004 at 4:16 pm

    #516170

    You can query sysprocesses table to see whats going on the server. This script might help you to find out which process is taking the most CPU? Once you know the spid, you can find out what that process is doing by either DBCC INPUTBUFFER(spid) or by using ::fn_get_sql function.

     

    SELECT cpu  ,spid  INTO cpu_hist

    FROM sysprocesses

    SELECT difference = p.cpu - u.cpu, p.cpu, p.program_name,p.loginame, p.spid,p. hostname, p.last_batch

    FROM sysprocesses p JOIN cpu_hist u

        on p.spid = u.spid

    ORDER BY 1 DESC

  • July 26, 2004 at 7:53 pm

    #516196

    Thanks for that

    Thanks,

    Kris

  • July 26, 2004 at 8:21 pm

    #516201

    You might create a custom SQL Server Agent performance condition alert with notification that dumps the info you are looking for while it is happening.

  • July 26, 2004 at 8:44 pm

    #516205

    If you are seeing system resources usage is high, run sp_who2 active to find out which spids are running.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply