locked
SQL Server Hang State RRS feed

  • Question

  • Hi,
    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.
    Friday, November 6, 2020 5:04 PM

All replies

  • Hi toorajazizi,

    Thank you for posting here.

    Since your question is more related to SQL Server, you can consider posting your question in the following forum for more help.

    sql-server-general

    Thank you for your understanding.

    Best Regards,

    Xingyu Zhao


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, November 9, 2020 6:51 AM