October 29, 2014 at 11:34 am
I received this error at 3:10 AM last night "Dispatch : Timeout during data retrieval due to busy server -- retry the operation (EtnPrdAP1) ARERR - 93" which made the DB inaccessible to users. I have no idea what this error is. I looked at the log file and alert through the monitoring tool but didn't see anything. Trace was running at that time as well but didn't see any job, any query which could have caused it. DB became inaccessible to users so a co-worker ended up restarting the App server (ARS Server) which resolved the issue. It happened couple of times already but can't figure out what's causing it.
Things I have already checked.
SQL Server logs.
Alerts through monitoring tool
Trace that I was running.
What else can be done?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 29, 2014 at 7:49 pm
It sounds like your app may have a connection leak (same symptoms as what we have at work but we can't change it... 3rd party hairball code). Less likely but still possible, it may have a memory leak. I could be wrong but this doesn't sound like it has anything at all to do with the DB or DB Server itself. Such things can be pretty tough to find in the code.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply