Azure SQL Database size increase

Question

Hi

After sql data sync is enabled the database size is growing rapidly.

How can we fix this and how can we track this

Answer 1

Hey there Nitya V

that's a good question and thanks for using QandA platform.

Lemme suggest you 2 ways to overcome this.

U can upgrade to hyoerscale,provides a highly scalable storage and compute performance tier that leverages the Azure architecture to scale out storage and compute resources for an Azure SQL Database substantially beyond the limits available for the General Purpose and Business Critical service tiers

this step-by-step tutorial,

Or you can upgrade to Azure SQL Managed Instance General Purpose for moe details follow the link below

https://techcommunity.microsoft.com/t5/azure-sql-blog/increased-storage-limit-to-16-tb-for-sql-managed-instance/ba-p/2421443

reference - https://learn.microsoft.com/en-us/answers/questions/1117548/how-to-increase-the-azure-sql-database-size

If this helps kindly accept the answer thanks much.