Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Wednesday, December 30, 2015 11:01 AM
Points: 107, Visits: 880
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 @ 7:03 PM
Points: 14,556, Visits: 38,432
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1467341
Posted Tuesday, June 25, 2013 1:31 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 619, Visits: 2,392
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: Monday, July 4, 2016 7:54 PM
Points: 9, Visits: 448
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: Wednesday, December 30, 2015 11:01 AM
Points: 107, Visits: 880
Thank you very much ..

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

Add to briefcase

Permissions Expand / Collapse