Today we are thrilled to announce General Availability (GA) of the database shrink in Azure SQL Database Hyperscale. This milestone marks another significant improvement in our Hyperscale service, providing our customers with more flexibility and efficiency in managing their database storage.
Overview
Database shrink in Azure SQL Database allows customers to reclaim unused space within their databases to optimize storage costs. Now this is available in Hyperscale service tier too. This feature has been highly anticipated by many customers, and we are excited to deliver it with robust capabilities and seamless user experience. This improvement needs no new learnings as the same DBCC SHRINKDATABASE and DBCC SHRINKFILE commands are used.
Database shrink was first announced for Hyperscale in public preview during last year. During the preview phase, we received invaluable feedback from our customers, which helped us refine and enhance this capability. We are grateful for the active participation and insights shared by the customers, which played a crucial role in shaping the feature.
Key features
- Storage Optimization: Database shrink effectively reclaims unused space, reducing the allocated storage footprint of your database.
- Cost Efficiency: By optimizing storage usage, customers can potentially lower their storage costs.
- Ease of Use: The feature uses the same syntax as what is available in other service tiers and in SQL Server. So, customers are able to seamlessly use existing scripts, minimizing disruption during adoption.
How to use
To help you get started with the shrink functionality, we have provided comprehensive documentation including example scripts. Here are the basic steps to implement database shrink in your Hyperscale database:
- Connect to your Hyperscale database through your preferred management tool such as SQL Server Management Studio, Azure Data Studio etc.
- Evaluate the free space available in the database.
- Execute the shrink command using the provided T-SQL (DBCC SHRINKDATABASE and DBCC SHRINKFILE).
- Optionally, you can monitor the shrink process through DMV to ensure successful completion.
- Review the reclaimed space and rerun by adjusting the parameters, if necessary.
Conclusion
The release of database shrink in Hyperscale is a testament to our commitment to continuous improvement in Hyperscale service tier. The General Availability of database shrink in Azure SQL Database Hyperscale is a major milestone, and we are excited to see the positive impact it will have on your database management.
You can contact us by adding to this blog post and we’ll be happy to get back to you. Alternatively, you can also email us at sqlhsfeedback AT microsoft DOT com. We are eager to hear from you all!
Updated Jan 29, 2025
Version 1.0Balmukund-Lakhani
Microsoft
Joined October 02, 2017
Azure SQL Blog
Follow this blog board to get notified when there's new activity