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!
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!
@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.
If you found your own solution, please share here with the community.
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.
8 people are following this question.
Unable to load data into Azure Synapse from ADLS Gen 2 .csv file
Azure Datafactory (copy data activity) : filter rows data before ingesting into datawarehouse
Error at create spark database in synapse workspace notebook using orchestrate pipeline.
Azure data lake storage Gen2 error external location not found