bob laughland (peter.mcclymont@gmail.com) writes:
Quote:
You mentioned sp_who. That is not really a viable option here because
I have no way to know when the slow query will kick in. Is there any
other way to check the locking?
There is the Blocked Process Report which you can trap in Profiler,
or with an event notification. I am not detailing this, because I
really should crawl to bed soon.
But I don't think this is a blocking issue, since you have such a
decrease in CPU and Reads.
--
Erland Sommarskog, SQL Server MVP,
esquel@sommarskog.se
Links for SQL Server Books Online:
SQL 2008:
http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005:
http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx 
