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

Mayank Jain 260 Reputation points
2023-09-25T10:26:31.7966667+00:00

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.

User's image

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,990 questions
Azure | Azure Startups
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 20,936 Reputation points Microsoft Employee Moderator
    2023-09-25T18:35:25.63+00:00

    @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


0 additional answers

Sort by: Most helpful

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.