Excessive waiting is happening on the following dominant wait type: CXCONSUMER

Question

We have found from the logs of SQL managed database that DB is taking more time. Also, after investigation, we found that " Excessive waiting is happening on the following dominant wait type: CXCONSUMER " message in the logs of the managed instance, which shows it's taking a longer time. Sharing the screenshot of the same. Requesting you to review the same and let us know, what can be done to fix this, so that we can respond to the request in the desired time frame.

Answer 1

@Mayank Jain Thank you for posting your question on Microsoft Q&A

The CXCONSUMER wait type occurs when a query is waiting for other threads to complete their work. This wait type is usually not a problem. That's a benign wait.  It just means that parallel plans are running.  SQL Server CXCONSUMER Wait (sqlskills.com) You should use Query Store to identify poor query perf: Monitor performance by using the Query Store - SQL Server | Microsoft Learn

Please let us know if you have additional questions or need some additional clarifications.

Regards,

Oury