If you think there is some locking, blocking going on then
you likely want to monitor this in SQL Server. You can start
by using the system stored procedures sp_lock, sp_who2 and
You may also want to take a look at the following article:
INF: How to Monitor SQL Server 7.0 Blocking
On Thu, 17 Feb 2005 08:39:09 -0800, "RG"