Script to find the main cuase of blockings

[isonlyme]

Hi all,

Does anyone knows a script to find out which process started a chain of blokings on SQL server 2k?

Thanks in advance

 

[TomKane]

Do select * from sysprocesses on the master database - the blocked field will show you the process number of the blocking process. Alternatively you can look in the current activity monitor

 

[isonlyme]

i'll do that

Thanks for the help!!

 

[tlbroadbent]

You can also use the stored procedures sp_lock and sp_who to identify blocked and blocking spids. To gather more information on blocking, check the following links.

INF: How to Monitor SQL Server 2000 Blocking

http://support.microsoft.com/default.aspx?kbid=271509

INF: How to View SQL Server 2000 Blocking Data

http://support.microsoft.com/default.aspx?kbid=283725

sp_blockinglocks.sql

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=131&lngWId=5

Capturing SQL Server Blocking Information

http://www.pinnaclepublishing.com/s...7FF774A8DC2AF6CC852568D9004AFB83?opendocument

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[isonlyme]

thanks for replying!!!!