october, 2019

wed16octAll DayI will speak at SQLdaysTransaction log - delayed durability and minimally logged operations in SQL Server(All Day: wednesday) Erdinger Stadthallen GmbH, Alois-Schießl-Platz 1, 85435 Erding, Germany

Abstract

SQL Server must log all data and schema changes synchronously in the transaction log to ensure durability, which has a strong performance impact on the system. This session (level 300) I will show how to improve the write performance of the transaction log by using minimally logged operations and delayed durability. As always, nothing is free, so I will also highlight the limitations and disadvantages of delay durability and minimally logged operation.