SQLTeam.com | Weblogs | Forums

SQL Server Hang

Today our sql server was hung for about one hour, I checked windows event viewer logs and I found this message:

Dispatcher (0x1220) from dispatcher pool 'XE Engine main dispatcher pool' Worker 0x0000018579056160 appears to be stuck on Node 0. Approx CPU Used: kernel 0 ms, user 0 ms, Interval: 623265.

Last week we had the same hanging sate but the error was this:

Process 62:0:7 (0x3ab4) Worker 0x00000066A0FD8160 appears to be non-yielding on Scheduler 0. Thread creation time: 13139533134164. Approx Thread CPU Used: kernel 0 ms, user 50156 ms. Process Utilization 97%. System Idle 1%. Interval: 73484 ms.

I don't know how to get rid of this problem, thank you.

What version of SQL Server is this? Please include the exact build number.

I would make sure you're fully patched.

Microsoft SQL Server 2019 (RTM-CU8) (KB4577194) - 15.0.4073.23 (X64) Sep 23 2020 16:03:08 Copyright (C) 2019 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor)

Is AG active?

No its not.