DELAYED DURABILITY WITH DELETE STATEMENTS

Problem : Log Writes bottleneck , Transaction waiting for WRITELOG which leads to I/O issues

Solution :

BEGIN TRAN
    DELETE FROM MyBigTable
    COMMIT WITH (DELAYED_DURABILITY=ON)

 

Leave a Reply

Your email address will not be published. Required fields are marked *