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 
