SQL Monitor: QDS_ASYNC_QUEUE Wait Type as Top Wait with 1 s/s
JoergH
Posts: 5 Bronze 1
Hi,
after activation of Query Store for 6 production databases (SQL Server 2017 Std. 14.0.3045.24), we see QDS_ASYNC_QUEUE as dominant Wait Type which adds 1 s/s wait time. Does someone observe the same on their servers? It seems to me that this might be a wait type that can be ignored (e.g. https://www.sqlskills.com/help/waits/qds_async_queue/) but I can't find published values for that wait type on other servers.
If this wait type can be ignored: Will it be added to an exclude-list in SQL Monitor?
Thanks in advance and regards,
Joerg Hencke
Tagged:
Best Answer
-
Russell D
Posts: 1,324 Diamond 5
Hi Joerg,
https://blogs.msdn.microsoft.com/shreyasgowda/2018/09/08/what-is-qds_async_queue-wait-type/ would seem to suggest that it isn't entirely benign?
Have you visited our Help Centre?
Answers
thanks and sorry - I read that blog post some time ago and didn't realize that fact.
In addition:
I got an answer from Paul Randall to my question "Is this a value you would expect and is this a wait type that can be put on the "ignore"-list?". He answered "Yup - entirely expected".
So, could you place a request for putting this wait-type on SQL Monitor's exclude-list?
Thanks and regards,
Joerg
We're happy that this is reasonable to count - if you want to though please do post this over on Uservoice here: https://sqlmonitor.uservoice.com/forums/91743-suggestions.