Re: Procedure execution problem - Clients performances

But it still strange..

Same procedure with same parameters executes in 1 sec in sql management
studio and get me timeout when executed in a .net application using
sqlclient.

but if i recompile the SP in SSMS both cases work well.

But after a time the problem repeats.. I see SSMS is not sensitive to query
plan as sqlclient is.

Robson

Robson

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OR2OQMbPIHA.5164@xxxxxxxxxxxxxxxxxxxxxxx
Sounds like parameter sniffing issue. Have a look at these:

http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx
http://blogs.msdn.com/queryoptteam/archive/2006/03/31/565991.aspx
http://omnibuzz-sql.blogspot.com/2006/11/parameter-sniffing-stored-procedures.html


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Robson Luiz" <robsonbr_2004@xxxxxxxxxxxx> wrote in message
news:%23mBc09ZPIHA.280@xxxxxxxxxxxxxxxxxxxxxxx
Hello people.

I have a strange behaviour with a stored procedure.

Using management studio procedure executes in 1 second.

Using a .net application (VS 2005) with sqlclient same procedure get me a
timeout execution..

Any help???

Best

Robson




.

Relevant Pages

  • Re: 2005 too smart for its own good?
    ... The program goes into debug mode when it gets to that line but BEFORE it executes that line. ... Which directory did you rename, the solution directory or the project directory? ... I renamed C:\Documents and Settings\cj\My Documents\Visual Studio ... The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: [PHP] $_SESSION variable gets lost on FORM action
    ... However, before that, my PHP scripts check if the session for this user ... If it detects a timeout, ... happens when the user is filling a form, the action that it executes ... I'm thinking that this is the problem because I've eliminated all the occurrences where the SESSION var was cleared until only one exists and it was after a Location Header. ...
    (php.general)
  • Async Timeout events for TCP connections.
    ... Is it possible in .Net to define a async timer callback. ... The reason I want to do this is to handle host being down that I am ... Then after a timeout automatically ... callback which if not cancelled executes within 15 seconds. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: how to determine the best timeout value
    ... Are you sure you are not being blocked when you timeout? ... > an xml document that is passed to the stored procedure in a string. ... > If I run the code that executes the stored procedure it executes fine ...
    (microsoft.public.sqlserver.connect)
Loading