Share via

getting 97% SOS_WORK_DISPATCHER and cannot find any information

Vijay Kumar 2,036 Reputation points
2022-09-22T18:04:44.587+00:00

Hi,

getting 97% SOS_WORK_DISPATCHER in one of my Azure SQL DB and cannot find any information

Azure SQL Database
0 comments
Accepted answer
  1. Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator
    2022-09-22T19:35:01.977+00:00

    Hi @Vijay Kumar Thank you for posting your question on Microsoft Q&A and for using Azure services.

    As per my understanding you are asking why you are seeing 97% SOS_WORK_DISPATCHER in one of your Azure SQL DB.
    The SOS_WORK_DISPATCHER wait type represents a sum of the total time for workers that don’t have tasks assigned to them. This appears to be a begin wait that can be filtered out of any queries on wait stats queries. There is nothing to worry about.

    Regards,
    Oury

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dan Guzman 9,406 Reputation points
    2022-09-22T18:35:14.267+00:00

    According to this page, SOS_WORK_DISPATCHER waits are simply when a thread in SQLOS is waiting for something to do. The wait reflects idle time and can be generally be ignored.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.