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)
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)