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

SQLServices getting restarted on same cluster node frequenty Expand / Collapse
Author
Message
Posted Wednesday, August 20, 2014 9:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:02 AM
Points: 3, Visits: 271
Friends,
We have 5 instances running on 2 node active-active cluster and frequently SQLServices are getting restarted on same node. The instances are running more than a year and issue is occurring only from past 2 weeks. Windows team suggested few hotfix and that haven't made any difference. Below is the error in event logs at the time of issue.

[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Server Native Client 10.0]Communication link failure
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
The SQL Server service terminated unexpectedly. It has done this 1 time(s).

Please suggest what needs to be checked as we find CPU and Memory normal on the server.

Regards,
Priya.
Post #1605490
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse