Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vijays3
Constraint Violating Yak Guru
354 Posts |
 Posted - 2013-11-14 : 06:20:24
|
| Hi AllMy table has only four records but it blocked by event select * from [dbo].[tb_SweptUserMultiplierTracker]Blocked by this eventEventType Parameters EventInfoLanguage Event 0 SET PARSEONLY OFFIf I retieve this using NOLOCK it is very quick .I cant understand why this blocked by the above mentioned event. Please advise on this.Vijay is here to learn something from you guys. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-11-14 : 10:16:17
|
how did you get the "Blocked by this event" information?What I usually do is:- get the SPID of the session that is running "select * from [dbo].[tb_SweptUserMultiplierTracker]" you can use this from the same window: select @@spid- sp_who2 active (while the blocking is occurring)- on the row(s) where SPID is your spid take the value of [BlkBy] as the input to:- dbcc inputbuffer(<blockedBySPID>) Be One with the OptimizerTG |
 |
|
|
|
|
|
Blocking issue