blocking and sp_who

[room24]

i have a custom system written in Delphi which runs from a sql server database. When users are on the system there is some blocking on the database. i can run sp_who to find out which users are blocking and who is being blocked. i am wondering how can i find out what stored procedure is contributing to the blocking or which command can i run to get more information in order to solve the problem. Anybody please help!!!

 

[hmckillop]

Have a look at aba_lockinfo, its a good stored proc when resolving deadlocks and blocking.
You can find it at:

http://www.sommarskog.se/sqlutil/aba_lockinfo.html

Select the version you need for your version of SQL

"I'm living so far beyond my income that we may almost be said to be living apart

 

[Andel]

Here's a script called showcodeline. It tells you what part of the stored proc is currently running. It even can see nested stored proc.

http://database.ittoolbox.com/brows...ing&r=http://vyaskn.tripod.com/fn_get_sql.htm

Andel
andel@barroga.net

http://www.iluko.com