Windows 2019 server freezes in 24 hours

Question

windows 2019 server freezes at 2 in night and when we stop sql server 2019 services it will not freeze

Answer 1

Bijoy there was a Service Update released can you check if you have this installed on the server? - https://www.bleepingcomputer.com/news/security/windows-10-kb5012636-cumulative-update-fixes-freezing-issues/

https://support.microsoft.com/en-us/topic/april-21-2022-kb5012636-os-build-17763-2867-preview-633385f3-07ef-4112-88e7-c7c5be026639

Also can you check if you have any scheduled backups or cron jobs running for SQL at that particular point? Disabled any scheduled tasks for a test.

Hope this helps.

JS

==

Please accept as answer and do a Thumbs-up to upvote this response if you are satisfied with the community help. Your upvote will be beneficial for the community users facing similar issues.

Answer 2

Hi @Bijoy Chandran,

To troubleshoot the issue, you can try the following steps:

Check the Event Viewer logs: Look for any errors or warnings related to SQL Server or any other system components around the time when the freezing occurs. This could give you some clues as to what is causing the issue.

Monitor system resources: Use Task Manager or Performance Monitor to monitor the server's CPU, memory, and disk usage. Check if any of these resources are maxing out when the freezing occurs.

Update SQL Server: Make sure you are running the latest version of SQL Server and that all updates and patches have been applied.

Review other scheduled tasks: Check if any other scheduled tasks are running at 2 AM that could be causing the issue.

Consider hardware issues: If the above steps do not resolve the issue, it could be related to a hardware issue, such as a failing hard drive or memory module. In this case, you may need to replace the hardware component or contact a professional to diagnose and fix the issue.

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".