Email this to a friend
posted on September 3rd 2015, at 11:05
by lunarg
Run the following T-SQL statements.

Show a list of longest running SPIDs on a SQL Server:

select P.spid, right(convert(varchar, dateadd(ms, datediff(ms, P.last_batch, getdate()), '1900-01-01'), 121), 12) as 'batch_duration', P.program_name, P.hostname, P.loginamefrom master.dbo.sysprocesses Pwhere P.spid > 50and P.status not in ('background', 'sleeping')and P.cmd not in ('AWAITING COMMAND' ,'MIRROR HANDLER' ,'LAZY WRITER' ,'CHECKPOINT SLEEP' ,'RA MANAGER')order by batch_duration desc

To retrieve the SQL for a specific SPID:

declare @spid int, @stmt_start int, @s  ...

Send a link to this post to yourself or a friend.

Send to e-mail:
Your name:
Your e-mail:
Type the letters and numbers as shown.
Not readable? Get another.
Information entered is solely used for sending a one-time e-mail, and is not retained and/or passed on to a third party.