Share via

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.
7,136 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
33 questions
0 comments
Accepted answer
  1. Oury Ba-MSFT 16,986 Reputation points Microsoft Employee
    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
Most helpful Newest Oldest