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

Database Engine becomes unresponsive Expand / Collapse
Author
Message
Posted Tuesday, June 18, 2013 12:22 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:44 AM
Points: 87, Visits: 1,512
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
Post #1464465
Posted Tuesday, June 18, 2013 3:04 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
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?
Post #1464519
Posted Wednesday, June 19, 2013 4:47 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:44 AM
Points: 87, Visits: 1,512
Thanks for your response.

Yes...its very random.
Post #1465058
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse