Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Engine becomes unresponsive


Database Engine becomes unresponsive

Author
Message
Denesh Naidoo
Denesh Naidoo
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 1677
Hi All,

Running MSSQL Server 2005 Enterprise Edition.

Recently there's been an upgrade to an application and ever since we are seeing an issue.

Randomly the application server starts reporting that it's unable to connect to the database. I'm able to remotely login on the SQL Server...but I'm not able to login on the database engine. It throws an "error occurred while establishing connection to SQL server"

There is no CPU or memory issue on the server. CPU is around 10% and free mem around 1GB

The resolution is to restart the app server...then SQL is fine. Once I can get in, checking the error logs...there are no errors of note. The only error I see is "I/O requests taking longer than 15 seconds" around the time the issue was experienced. Each time this happens, the I/O error is for different data files.

Checking the Event Viewer I see the following -
A timeout (30000 milliseconds) was reached while waiting for a transaction response from the MSSQLSERVER service.

I'm not sure if it's a connection issue with the application server...I'm not sure how I would investigate this

Looking at the wait types...there's nothing I see different to other SQL servers
SQL Show
SQL Show
Old Hand
Old Hand (395 reputation)Old Hand (395 reputation)Old Hand (395 reputation)Old Hand (395 reputation)Old Hand (395 reputation)Old Hand (395 reputation)Old Hand (395 reputation)Old Hand (395 reputation)

Group: General Forum Members
Points: 395 Visits: 1078
Denesh Naidoo (6/18/2013)

The resolution is to restart the app server...then SQL is fine. Once I can get in, checking the error logs...there are no errors of note. The only error I see is "I/O requests taking longer than 15 seconds" around the time the issue was experienced. Each time this happens, the I/O error is for different data files.



Can you check the drive system for any malfunctions? the error messsage is obvious with either Io issue or your IO is not be able to catch large number of transaction,(but in your case, you cant be able to login).

I see connection problem could be from different area. Is this connection failure is intermittent?
Denesh Naidoo
Denesh Naidoo
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 1677
Thanks for your response.

Yes...its very random.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search