March 24, 2006 at 3:15 am
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 10:21 am
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
the sp_Who provides the info i need.thank you for your reply.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply