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)