Friday, February 24, 2012

How to find cause of time-outs?

I am getting some .NET application exceptions saying the request to SQL
Server 2005 timed out. It is not always the same procedures that time out.
It is also very intermittent. How can I find out which SQL tasks are
running slow or to blame? I don't know where to look, what to log, etc.
.NET can't tell me more from its end.You could start by taking a look at this article on how to monitor
blocking.
http://support.microsoft.com/defaul...b;en-us;271509.

No comments:

Post a Comment