March 25, 2020 at 4:33 pm
My Azure SQL Database Tips from real life ??
On premium subscription
Restore 1.5 TB database to point in time takes ~ 10 hours
Truncate 100 rows ,100K or 958M rows from table located in azure sql database takes same time ~2 seconds ??
DBCC SHRINKDATABASE will bring DTU to 100% for all execution period (because of I/O operation)
Database Shrink speed ~80 GB/hour
You can minimize impact on application if you shrink 5% at the time
If you start from 1.5 TB allocated space
DBCC SHRINKDATABASE([You db name ],95) --duration -30 min
DBCC SHRINKDATABASE([You db name ],90) --duration -16 min
DBCC SHRINKDATABASE([You db name ],85) --duration -16 min
DBCC SHRINKDATABASE([You db name ],80) --duration -16 min
March 26, 2020 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy