Get-DbaWaitStatistic Should Filter Out SOS_WORK_DISPATCHER By Default

[ReeceGoding]

Summarize Functionality

Reliable sources consider SOS_WORK_DISPATCHER a benign wait added in SQL Server 2019. Whenever I run Get-DbaWaitStatistic on a server on any 2019 or later version, more than 90% of my waits are SOS_WORK_DISPATCHER. It should be filtered out by default. Currently, the function's code makes no mention at all of that wait type. This is unsurprising, given that the place its underlying query was taken from is from prior to 2019.

Is there a command that is similiar or close to what you are looking for?

Yes

Technical Details

I believe that all that needs to be done to implement this is to add 'SOS_WORK_DISPATCHER' to the list that forms the $ignorable variable in the definition of Get-DbaWaitStatistic.