Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

unexpected Error occured in the database server Time out expired Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 1:14 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 8, 2013 9:46 AM
Points: 101, Visits: 842
Hi all ,

Application team mail me this error...
I checked the no timeout error in SQL server error log...
No I/O related error , even eventvwr not showing any thing...

but this is second time application team saying they are getting this error , plz suggest how to monitor it.

As i m checking with monitor disk counters and sql buffer counter as it is also normal


Regards,
Shivrudra W
Post #1467337
Posted Tuesday, June 25, 2013 1:21 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:07 PM
Points: 12,910, Visits: 32,028
that's an application error,and not SQL server.

a lot of applications will have a default connection timeout of 30 seconds, unless someone explicitly adds some longer timeouts to the connection string.

if the app then runs a query that is long running, the application throws it's hands up after thirty seconds and returns an error, even though SQL server is still working on returning the results/finishing the desired query.


you could check the DMV's for long running queries, but it would be better to throw this in the lap of the applications team and tell them they are timing out ; have the original user report what exactly they were running that took a long time.

this might help find some of your slower queries:
select 
fn.*,
st.*
from sys.dm_exec_query_stats st
cross apply sys.dm_exec_sql_text(st.[sql_handle]) fn
where st.max_elapsed_time >= (1000 * 15) --15 seconds



Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1467341
Posted Tuesday, June 25, 2013 1:31 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 2:59 PM
Points: 443, Visits: 1,394
It also could happen as a result of blockings. Check if application's S.P. are blocked during their execution.
Post #1467349
Posted Tuesday, June 25, 2013 1:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 16, 2014 2:48 PM
Points: 9, Visits: 435
Could be due to locking . You can monitor this with profiler .
Post #1467353
Posted Tuesday, June 25, 2013 4:18 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 8, 2013 9:46 AM
Points: 101, Visits: 842
Thank you very much ..

Regards,
Shivrudra W
Post #1467404
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse