February 25, 2014 at 9:17 am
How do I troubleshoot loss of connection with SQL server? How do I even find out what caused it? Any help will be much appreciated
"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]
February 25, 2014 at 9:25 am
Can you be a little more specific?
February 25, 2014 at 9:27 am
The application disconnected from the DB and we received a message stating the DB was unavailable last night.
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (SQL Server 11)
Tue Feb 25 01:13:19 2014 lastsql BEGIN TRANSACTION
Tue Feb 25 01:13:20 2014 390620 : The SQL database operation failed. (ARERR 552)
Tue Feb 25 01:13:20 2014 [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (SQL Server 11)
Tue Feb 25 01:13:20 2014 lastsql SELECT TOP 2 T431.C1 FROM T431 WHERE ((T431.C875025003 = 4) AND (T431.C1 IN ('-1'))) ORDER BY 1 ASC
Tue Feb 25 01:13:20 2014 390635 : The SQL database operation failed. (ARERR 552)
Tue Feb 25 01:13:20 2014 [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (SQL Server 11)
Tue Feb 25 01:13:20 2014 lastsql SELECT TOP 101 T277.C1,C18092,C18090,C18099,C18083 FROM T277 WHERE ((T277.C18093 = 'AGGAA5V0HDQ8ZAMWYIM9IFHKZ1IUK6') AND (T277.C18098 = 1) AND (T277.C18092 = 0)) ORDER BY 1 ASC
Tue Feb 25 01:13:22 2014 Archive : The SQL database operation failed. (ARERR 552)
Tue Feb 25 01:13:22 2014 [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (SQL Server 11)
Tue Feb 25 01:13:22 2014 lastsql SELECT T669.C1 FROM T669 WHERE (T669.C3 <= (1393312383 - (86400 * 14))) ORDER BY 1 ASC
Tue Feb 25 01:13:23 2014 390620 : The SQL database operation failed. (ARERR 552)
Tue Feb 25 01:13:23 2014 [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (SQL Server 11)
Tue Feb 25 01:13:23 2014 lastsql SELECT helpText,changeDiary,owner,lastChanged FROM field WHERE (schemaId = 277) AND (fieldId = 1)
"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]
February 25, 2014 at 9:30 am
Have you asked your networks guys if anything happened around that time?
February 25, 2014 at 9:33 am
Well I can ask them but how do I even know if its a DB issue? How do I check the log. The log I posted, it was sent to me by my Manager.
"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]
February 25, 2014 at 9:46 am
I RDP into the server. Went to event viewer->windows log-> application. Is this the right place to start looking for errors?
"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]
February 25, 2014 at 9:51 am
It looks like error message 1 here to me?
February 25, 2014 at 9:51 am
Sorry- another double post. I would get your networks guys involved.
February 25, 2014 at 10:29 am
It could be a Network Glitch or a DB issue. Check the Windows Application Log and SQL Server Logs to see if it's a DB issue.
--
SQLBuddy
February 25, 2014 at 10:34 am
I checked the application log but I don't see no error. It's either warning or information.
"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]
February 25, 2014 at 10:37 am
Did you check on the Application server or on the DB server ..
--
SQLBuddy
February 25, 2014 at 10:40 am
DB server.
"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]
February 25, 2014 at 10:43 am
Check if the DB server got restarted at that point of time .. Also good to check the SQL Server Error Logs for any specififc errors at that point ..
--
SQLBuddy
February 25, 2014 at 10:50 am
I don't think the service was restarted since I don't see anything in a log.
"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]
February 25, 2014 at 11:06 am
I don't see any DB related errors from the app log. Also the attachment doesn't show anything close to 1:13 AM.
Check with your network admin if there was any network outage that affected this loss in connectivity.
Also check the SQL Server error logs for any issues ( In SSMS --> Click on Management Node --> SQL Server Logs )
--
SQLBuddy
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply