Synapse Analytics Shrink Database
Published Jul 31 2020 01:51 PM 3,119 Views

In the event that you have a large Synapse Analytics Database and you have been cleaning out large objects which were no longer required consider running a shrink on your database  to reduce your database size on disk. Since July 2020 we now officially support the execution of DBCC ShrinkDatabase within Synapse Analytics.


The functionality works the same was as SQL Server and we have the same guidelines when using it, for additional information review our official documentation.


Or just execute the statement from your User database. 


DBCC ShrinkDatabase('DATABASENAME') 



The Shrink Operation is an IO Intensive operation, It is advised to perform the operation with no other activities running on the database. The Shrink operation can take the Synapse Database Offline.


If you have very large CCI Objects consider rebuilding your CCI Objects with the largest RC available to ensure the highest quality row groups and to optimized the overall shrink operation. 


To determine the amount of unallocated space before running the shrink, run an sp_spaceused on your database and review the output to determine if it is necessary to perform the shrink. 


Do not shrink frequently or make this part of regular maintenance. 


Take into consideration that the shrink operation will have an affect on the data warehouse snapshot charges.  

Version history
Last update:
‎Jul 31 2020 01:51 PM
Updated by: