Database storage space

Question

Database storage space

Maitra-v, Anirban 141

I want to know the storage space of Azure Synapse dedicated Sqlpool. As per the attachment does it mean that total size as of now 131 GB and it can go unlimited(Space Available as per screenshot is Not Applicable)

1 answer

Your answer

Answer 1

Bhargava-MSFT 31,356 Microsoft Employee Moderator

Hello @Maitra-v, Anirban ,

Welcome to the Microsoft Q&A platform, and thanks for posting your query.

As per the below Microsoft documentation, the Max size is 240TB compressed on disk.

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits#workload-management

Dedicated SQL pool size:
Gen1: 240 TB compressed on disk. This space is independent of tempdb or log space, and therefore this space is dedicated to permanent tables. Clustered columnstore compression is estimated at 5X. This compression allows the database to grow to approximately 1 PB when all tables are clustered columnstore (the default table type).

Gen2: Unlimited storage for columnstore tables. Rowstore portion of the database is still limited to 240 TB compressed on disk.

You can see this from DB properties.

Please let me know if this is helpful. If you have any further queries, please let us know

Maitra-v, Anirban 141 Reputation points

2022-07-16T02:43:30.377+00:00

Thank You. So basically it will depend on the DWU. So for DW100c, the max size of the database is 128 GB and if we want to increase the database size, we need to go for higher DWU. Is that understanding correct?
Bhargava-MSFT 31,356 Reputation points Microsoft Employee Moderator

2022-07-16T15:11:46.283+00:00

Hi @Maitra-v, Anirban ,

DWU is a combination of CPU, memory and IO.(it's called Compute power). When you increase DWU of your dedicated SQL pools, you will get more compute power.

DB storage is an independent component. My understanding is even if you have DW100c, your DB can grow up to 240TB(This is the max limit for DB storage).

I believe autogrowth is enabled by default on the azure SQL pools. When your data size grows, the DB size automatically increases up to max 240TB.

You can use below queries to see the size.

sp_spaceused

select sum(used_page_count) / 8.0 / 1024 total_size_mb
from sys.dm_pdw_nodes_db_partition_stats

Dedicated SQL pool leverages Azure Storage. Since your data is stored and managed by Azure Storage, there is a separate charge for your storage consumption.

Please see the below architecture document to understand SQL pools storage.

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture

for your question, to increase the DB size, you don't need to add more DWUs. DB storage is an independent component.
Bhargava-MSFT 31,356 Reputation points Microsoft Employee Moderator

2022-07-19T01:37:23.047+00:00
Hello @Maitra-v, Anirban ,
I am checking in to see if the above answer helped. And if you have any further queries, do let us know.

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
Bhargava-MSFT 31,356 Reputation points Microsoft Employee Moderator

2022-07-20T03:40:50.097+00:00

Hello @Maitra-v, Anirban ,
I am checking in to see if the above answer helped. And if you have any further queries, do let us know.

Share via

Database storage space

1 answer

Your answer