Synapse Dedicated Pool utilization

[imranshabbir]

Hello Everyone,

I'm encountering an issue with Synapse where my capacity, set at DW3000c, is being fully utilized even when only 2-3 queries are running.During the execution of queries I also observe the resources but it didnt change after the completion of the queries. I'm unsure how to trace the root cause of this problem. I've attached a screenshot for reference.

Thanks

[Anonymous]

Hi @imranshabbir ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

HI @imranshabbir,

What type of synapse are you worked on? Azure synapse or fabric synapse? 

Comparison between Fabric and Azure Synapse Spark. - Microsoft Fabric | Microsoft Learn

What type of processing are you executed? How did you configure the spark environment and compute settings? Can you explain and share more detail information about these?

Compute management in Fabric environments - Microsoft Fabric | Microsoft Learn

BTW, if you want to know more about spark monitoring, you can check the following link:

Apache Spark monitoring overview - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng