Database storage space

Maitra-v, Anirban 141 Reputation points
2022-07-15T20:09:34.397+00:00

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 Availa221341-database-size.pngble as per screenshot is Not Applicable)

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,140 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 24,271 Reputation points Microsoft Employee
    2022-07-16T01:39:28.61+00:00

    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.

    221267-image.png

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