Advertisement
Guest User

Untitled

a guest
Aug 29th, 2016
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. select
  2. P.spid
  3. , right(convert(varchar,
  4. dateadd(ms, datediff(ms, P.last_batch, getdate()), '1900-01-01'),
  5. 121), 12) as 'batch_duration'
  6. , P.program_name
  7. , P.hostname
  8. , P.loginame
  9. from master.dbo.sysprocesses P
  10. where P.spid > 50
  11. and P.status not in ('background', 'sleeping')
  12. and P.cmd not in ('AWAITING COMMAND'
  13. ,'MIRROR HANDLER'
  14. ,'LAZY WRITER'
  15. ,'CHECKPOINT SLEEP'
  16. ,'RA MANAGER')
  17. order by batch_duration desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement