468,316 Members | 2,116 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

Re: Queries Occasionally Slowing Down

bob laughland (pe*************@gmail.com) writes:
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, es****@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

Nov 20 '08 #1
0 1015

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Simon Withers | last post: by
16 posts views Thread by TheKeith | last post: by
6 posts views Thread by Hennie7863 | last post: by
3 posts views Thread by Dan Stromberg | last post: by
7 posts views Thread by Chris Thompson | last post: by
16 posts views Thread by shawno | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.