SQL Timeout

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Hello all,

I have an unusual problem with an app I've written.

The app connects to a database, calls a stored proc and returns data -
all very standard. When I run the SP in SQL SERVER, it takes 0.1
seconds to run, very quick. But when I run it via the web app, it
times out.

I'm using the Microsoft.Practices.EnterpriseLibrary.Data assembly and
running the SP via this.db.ExecuteDataSet(objComm).Tables[0].

Why would this be? Anyone have similar experiences or know what it
could be?

Any help would be great.

Regards,

Jon
 
I prefer the LoadDataSet method btw.

Regardless, google "Parameter Sniffing" "Sql Server". Its a leading culprit
for that type of behavior.
 
I prefer the LoadDataSet method btw.

Regardless, google "Parameter Sniffing" "Sql Server".  Its a leading culprit
for that type of behavior.




Hello all,
Click to expand...
I have an unusual problem with an app I've written.
Click to expand...
The app connects to a database, calls a stored proc and returns data -
all very standard. When I run the SP in SQL SERVER, it takes 0.1
seconds to run, very quick. But when I run it via the web app, it
times out.
Click to expand...
I'm using the Microsoft.Practices.EnterpriseLibrary.Data assembly and
running the SP via this.db.ExecuteDataSet(objComm).Tables[0].
Click to expand...
Why would this be? Anyone have similar experiences or know what it
could be?
Click to expand...
Any help would be great.

Jon
Click to expand...
Click to expand...

Cheers for this Sloan,

Seems to have helped a alot!
 
Back
Top