Post reply

how do i view what sprocs are runing and their status

  • March 24, 2006 at 3:15 am

    #103131

    is there a way i can monitor all the sprocs that are running on a server , and their status, rather than use a simple trace? is there a tool in sql server 2005 for monitoring of performance, sprocs & objects in memory, locks and various other things??

  • March 27, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • March 27, 2006 at 10:21 am

    #628974

    The best thing to start with is probably "sp_who" or "sp_who2". That will at least show you what processes are running in SQL and whether there is any blocking going on. There are ways to find out what statement a particular process is working on.

    DBCC INPUTBUFFER (spid) -- replace spid with the actual numeric value

    or

    DECLARE @handle binary(20)

    SELECT @handle = sql_handle FROM master..sysprocesses

    WHERE spid = SPID -- replace with actual numeric value

    SELECT [text] FROM ::fn_get_sql(@handle)

  • March 28, 2006 at 1:04 am

    #629088

    the sp_Who provides the info i need.thank you for your reply.

Viewing 4 posts - 1 through 3 (of 3 total)

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