how to know the size of sql dedicated pool in synapse

Question

I am using DW200C in my SQL dedicated pool. In my reporting side, getting data very slow and performance also not that much great.

I need to know the size of Azure Synapse SQL dedicated Pool and need to check the performance imrpovement based on the memory.

Kindly help me to resolve this issue for me.

Thanks

Answer 1

@Kalidas Yerravarapu Thank you for posting your query on Microsoft Q&A and for using Azure services.

In my understanding you are looking to know the size of Azure Synapse dedicated SQL pool.

The size of a dedicated SQL pool (formerly SQL DW) is determined by Data Warehousing Units (DWU). Read more on What is dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics?
For furthermore details on how to find performance tiers, Datawarehouse Units, and how to view the current settings of DWU. Please check this Data Warehouse Units (DWUs) for dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics

Please let me know if this is helpful. If you have any further queries, please feel free to reach out.

Regards,
Oury

Answer 2

@Kalidas Yerravarapu Sorry for the delay in response to the above question.
Yes, the database size is determined by Data warehousing units. You can change the data warehouse units by scaling the DWU setting in the Azure portal to increase the database size.

Please let me know if this is still unclear. I will be more than happy to help you with any queries.

Regards,
Oury

·

Answer 3

Hi @Oury Ba-MSFT thanks for your reply. Sorry for delay in response, stuck up with some other priority tasks.

I am very much happy with your answer.

Thanks again!

Regards,

Kalidas