July 29, 2013 at 5:11 am
i would like to find the spid of the long running job with a query ? can any one send me the query
July 29, 2013 at 12:22 pm
select * from master..sysprocesses where spid > 50 and status = 'runnable'
July 29, 2013 at 5:29 pm
exec sp_who2
July 29, 2013 at 10:44 pm
download and install sp_whoisactive
http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply