MS SQL - Consultar pid que esta mais tempo rodando

--Consultar pid que esta mais tempo rodando

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.loginame

from master.dbo.sysprocesses P

where P.spid > 50

and      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

fonte: http://stackoverflow.com/questions/941763/list-the-queries-running-on-sql-server