Slowness, Timeout errors and .NET and SQL Server

Last Post 03 Dec 2006 02:29 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

25 Sep 2006 06:48 PM
hi, all:

Ok, I have an SP that is called from a .NET webapp, and it takes 24+seconds, while in Query Analyzer it takes 2 seconds. First there were timeouts if exceeded 30 secs, now down to 24+. So, while it doesn't hit the timeout, it still takes too long.
I already recompiled, rebuilt indexes, remote query and login timeout set to '0', etc., etc. The timeout setting in the web.config file is 120 (2mins) - no blocking, no deadlocks, nothing in the trace, other to show its exactly 30 secs before timeout thru app.
Now, we pointed the production web server to test SQL (same code, db, config parms, SP, service packs, etc, and it returned the data rather quickly w/no timeouts. So, their pinning their accusation on the database, and I'm stuck like a pig in a polk
First, any idea why it takes much longer thru web app, than SQL? We also tried connecting thru access natively, and it too takes 24+secs.
1) How can I prevent timeouts; 2)why does it take much longer, please explain??
New Member
New Member

03 Dec 2006 02:29 AM
Can you list the SP? Also how you call it?

This maybe a result of how you setup the sp, default handling for example.

Kalman Toth DB, DW & BI Architect, SQL Server Training
The Best SQL Server 2005 Training in the World

Acceptable Use Policy