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)