Time Out error for application -- sql server (microsoft)

rittyta NO[at]SPAM gmail.com
5/24/2007 8:59:48 PM

Hi,
One of my application with around 20 tables was workng fine for
quite a long time ...now it started giving error for users saying
"Time out period elapsed prior to completion of the operation or the
server is not respondig" My tables are not that big ..one of the
tables have 100000+ records all other less than this. I access the
tables throgh Views which have NOLOCK specifed on it. I checked Indexs
it seems to be good .Whn I execute the SPs through Query Analyser it
respond quite fast....

The Application is used by 10-15 users at a time maximum...

Please suggest some way I can make my application working normal..
Thanks in advance

Ritz

JPhelpstead NO[at]SPAM gmail.com
6/7/2007 8:13:38 AM

[quoted text, click to view]

Hi Ritz,

Have you checked some of the following -

1. Is the ping time between the application and SQL Server degraded in
any way?
2. Do you have a firewall between the application and the SQL Server?
3. You say that the SP's work fine, are you running these on the SQL
Server or from a machine which has your application on?
4. Have you put a performance monitor on the server to check that it
isn't running low on resources?

Thanks
James

Senior SQL Server Developer

sql server (microsoft) : Time Out error for application