august, 2019

thu08aug6:30 PM8:30 PMI will speak at SQL PASS Hamburg Performance optimization of the transaction log in SQL Server6:30 PM - 8:30 PM Microsoft Hamburg, Gasstraße 6A, 22761 Hamburg, Germany

Abstract

In this session (Level 300) we will understand what influence the transaction log has on the performance of SQL Server. We’ll look at which operations SQL Server logs, comparing the recovery models for performance. In this context, we will also deal with bulk-logged operations and delayed durability.