Re: Timeout Expired Errors - Need Expert Consultant - Have done a ton of research already

From: Eric Margheim (eric_at_prism-grp.com)
Date: 02/25/04 

Date: Tue, 24 Feb 2004 23:52:30 -0600

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:uNwbBsx#DHA.3384@TK2MSFTNGP11.phx.gbl...
> Timeout issues can be caused by a number of problems. Typically they are
> caused by a deadlock condition where one process is holding a resource
while
> attempting another operation. If the process blocking the operation is
doing
> the same thing you're locked out and pooched. The system can detect this
in
> some cases.
>
> I think the OUTPUT parameter issue may be a red herring--not related to
the
> problem.
>
> Consider that the query plan is created the FIRST time a SP is executed
and
> reused indefinitely until it's pushed out of cache by more important data.
> The query plan is created based on the input parameters. If these vary
from
> call-to-call the "optimal" plan might vary quite a bit. The trick here is
to
> simplify the SP so instead of calling one 400 line SP, you're calling four
> 100 line SPs (that call each other as required).
>

Interesting. Thanks for the info.

Relevant Pages