question

Pm-3513 avatar image
0 Votes"
Pm-3513 asked SumanthMarigowda-MSFT edited

Detecting ADLS Throttling

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-synapse-analyticsazure-data-lake-storage
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Pm-3513 did my response help you? If it solved your issue, please mark as accepted answer. If not, please let me know how I may better assist.

0 Votes 0 ·

If you found your own solution, please share here with the community.

0 Votes 0 ·

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered

Hello @Pm-3513 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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.