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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-08-31 : 09:57:13
|
| Hi just read an article on the internet that states"A quick way to resolve a blocking problem is to disconnect the connection blocking the rest of the users. All you have to do is ask your database administrator to execute the KILL statement. Obviously, this is not a permanent solution, and won't really help anything except take care of an immediate need."Now when i run sp_who ... i see that the spid that is blocking is the same as the spid itself.... Now the above article states that killing the one that is blocking the rest of the other spids is ok ...But what if its the same SPID that is blocking ...what does it signify & whats the solution Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-31 : 10:00:46
|
| That's usiually because the spid is running multiple threads. The main thread is waiting for another thread to complete and is showing as blocked by it.It was a change made in sp4.It's probably nothing to worry about.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Blocking