Share via

Detecting ADLS Throttling

pm-syn-lover 36 Reputation points
2021-06-16T19:44:59.907+00:00

In search of a way to check whether my ADLS Gen2 storage account is throttling, as querying through serverless in Azure Synapse has become a bit slower. How can I check this? Thank you for your help!

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,463 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,860 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MartinJaffer-MSFT 26,081 Reputation points
    2021-06-17T21:58:56.727+00:00

    Hello @pm-syn-lover and welcome to Microsoft Q&A.

    There are a couple ways I could look at this question, through the lens of storage, or the lens of Synapse.

    From the storage perspective, we can check out the metrics of the container, specifically looking at the transactions by response type.

    From the Synapse perspective, I would need you to tell me a little more about what you are doing, and what is happening.
    One possibility, is the openrowset query is too broad, and looking at more files than you intended, even if they are not being used.

    0 comments

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.