SQL Server Performance Tuning and Optimization

SQH04 The Transaction Log and How It Affects High Availability and Disaster Recovery

11/21/2013

8:00am - 9:15am

Level: Intermediate to Advanced

Edwin Sarmiento

Managing Director

15C

When choosing the appropriate SQL Server High Availability and Disaster Recovery (HA/DR) solutions, it is important to understand the SQL Server Transaction Log as it affects any solution you choose. In this session, we will look at transaction log basics, how logging and recovery works and how it affects all of the HA/DR solutions available in SQL Server. You'll be surprised to know that the transaction log is the most important part of your database.

You will learn:

  • How the transaction log works
  • How the transaction log affects all of the SQL Server HA/DR solutions that you choose
  • How to properly take care of the transaction log for performance and HA/DR