question

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 asked KalyanChanumolu-MSFT answered

Azure Sql db

Hello Team,

I have 1 Azure SQL DB(15 Tables) of 1 TB.I need to clean the Azure SQL DB. Please advise me can i do the DBCC SHRINKDATABASE. So that it can reduce the size.

If no,Please advise me the correct suggestion to reduce the size of the DB.


Regards
Rohit

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered

@RohitKulkarni-6062 Thank you for reaching out.

You can use SHRINKDATABASE if you have a high number of Truncate, Delete table operations or ETL operations on this database
Otherwise, it is usually not required to manually shrink a database. Some best practices are here

Please be aware that after shrinking the database, indexes may become fragmented and lose their performance optimization effectiveness.
You should use an index maintenance solution like SQL Server Index and Statistics Maintenance to rebuild and reorganize indexes after a shrink operation.

Do let us know if you have any further questions.


If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.