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

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 02/24/04

  • Next message: Yama: "Re: Accessing FoxPro Free Table" 
    Date: Tue, 24 Feb 2004 13:13:07 -0800

    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). 

    -- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Eric Margheim" <eric@prism-grp.com> wrote in message
news:O791Q3u%23DHA.3272@TK2MSFTNGP09.phx.gbl...
> I have a ATL DLL running in COM+ Applications that communicates with SQL
> Server via ADO Command Object.   We occasionally get Timeout Expired
errors
> with one method that is used to call stored procedures that return output
> parameters.    The error can come back quickly or take a while.
>
> I have done a ton or research.   Have looked into Connection Pooling
issues,
> ODBC settings, ADO, etc.
>
> I need a consultant who is an expert in COM+, ADO and SQL Server to help
me
> debug this.   Please contact me privately if you can help.   I'm willing
to
> pay an hourly rate if you can help me solve this issue.
>
> Thanks
>
>
  • Next message: Yama: "Re: Accessing FoxPro Free Table"

    Relevant Pages
    Loading