July 31, 2013 at 2:02 am
Hi Team,
I used to run 'sp_who2' to check the locks, i found that some sp_id are showing in BlkBy column, and in command column it is showing as 'Select'
I to find the full query, which is blocked.
July 31, 2013 at 2:07 am
one method is to use dbcc inputbuffer
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
July 31, 2013 at 2:10 am
hi,
Using DBCC INPUTBUFFER(<spid>)
but am not getting the full query.
July 31, 2013 at 2:12 am
Is your query running a loop, cursor or does it have multiple batches within it?
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
July 31, 2013 at 2:17 am
Hi Jason,
there is no Loop and cursors, it is a simple select query, is there any other way (without using 3rd party tools) to get the full query which is Blocked.
Please suggest.
July 31, 2013 at 2:23 am
You can try the query in this article
http://www.sqlservercentral.com/articles/sp_who2/70222/
You can also try sp_whoisactive (link in the discussion on that article.
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
July 31, 2013 at 2:42 am
Thank You Jason,
i'll check the link and revert back if any queries.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply