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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2009-09-24 : 06:09:41
|
| When you see a number in the BlkBy column, eg. I saw 5 for a SELECT, and an 82 for an AUTOSHRINK; usually with just a dot in there - what does that mean?Thanks |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2009-09-24 : 13:47:12
|
| The BlkBy column shows the SPID of the connection that is blocking this row. You need to then check that SPID's last executed statement to try to identify what the issue is.The dot is just a placeholder meaning that nothing is blocking it.Note that short-term blocking is a normal occurrence, so don't stress about that unless it goes on for a while.--------------------------------------------Brand yourself at EmeraldCityDomains.com |
 |
|
|
|
|
|
Running sp_who2 active