Windows Server hang

Question

Hello,

Win 2016 servers are installed in my environment and Sql is available on these servers. Recently, these servers occasionally hang from time to time and sql connections are broken. At the time of hang, RDP cannot be done to the server, ping can be pinged, the services of the server with hang can be accessed via another server, smb shares are also coming.

Again, when I try to enter a password on the password screen via the vm console to the server at the time of hang, it gets an error that it cannot find the domain. The server stands up after a while, this time varies from 10 minutes to 30 minutes to 1 hour.

In the log checks I made when the server stood up, 1688 event logs appear in the system logs. In this log, there are logs that the Cluster object was disable and failed when trying to enable it.

Unfortunately, no memory.dump file is created on the server.

Has anyone experienced a similar problem? I would like to ask those who have experience to share what the problem may be caused by.

Translated with DeepL.com (free version)

Answer 1

Hello

Thank you for posting in Q&A forum.

The symptoms you described, including the server hanging, SQL connections breaking, and RDP issues, can be caused by several factors. Here are some steps you can take to troubleshoot:

1. Use Performance Monitor or Resource Monitor to check for high CPU, memory, or disk usage during the times when the server hangs. Ensure that SQL Server is not consuming excessive resources. Check for long-running queries or high transaction log usage.
2. The 1688 event log indicates issues with the Cluster service, which might be related to your problem, review the Cluster logs for any related errors.
3. Ensure that your DNS settings are correct, and that the server can resolve domain names properly. Check for any network latency or connectivity issues that might be affecting the server's performance.
4. Run memory diagnostics to check for any memory leaks or hardware issues. Look for any signs of memory leaks in the application logs, especially related to SQL Server or other critical applications.
5. Ensure that your antivirus software is not interfering with the server's operations. Sometimes, antivirus scans can cause performance issues. Review security logs for any unusual activity that might be affecting the server.

I hope the information above is helpful.

If you have any questions or concerns, please feel free to let us know.

Best Regards,

Daisy Zhou

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.