Hello Experts,
SQL server is in windows cluster 2012 and it is in VM ware. Some times this server is going hung state and it is fail over to another node with out showing any error message.
And there was no activity in background to at least to assume there is something.
But last time i heard that it is because of Vmotion and holding sql server log files and trying to move to another vm node. But this time there is no error message but sql went to stopped state.
Is there any method to capture the information why sql server and windows server is going to hung state?
This is the large error message i found it before it went to stopped state.
Cluster resource 'SQL Server' of type 'SQL Server' in clustered role 'SQL Server (MSSQLSERVER)' failed.
Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet.
