My Azure SQL Database Tips from real life

  • ebooklub

    Hall of Fame

    Points: 3900

    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

  • Site Owners

    SSC Guru

    Points: 80378

    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