I've recently inherited a SQL Server 2017 instance with performance issues and I've been able to remediate the low hanging fruit. However, one substantial wait still remains.
The Query Store - qds_async_queue seems to be significantly high. But I'm unable to find any meaningful documentation or insight. Microsoft's online description has been at 'TDB' since SQL 2016.
Does anyone have any insight or helpful information about this wait?