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.

Organizer

ppedv AG Campus Marktler Straße 15b, 84489 Burghausen, Germany

Time

All Day (Wednesday)

Venue

Erdinger Stadthallen GmbH

Alois-Schießl-Platz 1, 85435 Erding, Germany