Reader small image

You're reading from  Getting Started with SQL Server 2014 Administration

Product typeBook
Published inApr 2014
PublisherPackt
ISBN-139781782172413
Edition1st Edition
Right arrow
Author (1)
Gethyn Ellis
Gethyn Ellis
author image
Gethyn Ellis

Gethyn Ellis has over eighteen years of experience with SQL Server and for past ten years he has been working on Azure. He is an Microsoft certified trainer. He also trains and is a consultant for SQL Server. Prior to this he has worked with Packt and written books on "Getting Started SQL Server 2014 Administration" , "Microsoft Azure laaS Essentials", and Professional Azure SQL Database Administration.
Read more about Gethyn Ellis

Right arrow

Full Durability versus Delayed Durability


There are some factors to consider when deciding on whether to use Full or Delayed Durability. These include:

  • Data loss: If you can accept some data loss and the performance of the system is more important than the recoverability of certain transactions, then Delayed Durability could be an option for you.

  • Bottleneck on transaction log writes: After careful analysis of your system wait stats, you concluded that you are suffering from performance issues. This could be due to latency when writing to the transaction log, and you can accept some data loss in the event of a system crash or restart. In which case, Delayed Durability could be an option to solve this performance issue.

  • A high contention workload: If your wait stat analysis shows that your performance slowness is caused by the delay in locks being released, then Delayed Durability could be an option. It helps remove the contention as it reduces the commit time and as such locks will be released...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Getting Started with SQL Server 2014 Administration
Published in: Apr 2014Publisher: PacktISBN-13: 9781782172413

Author (1)

author image
Gethyn Ellis

Gethyn Ellis has over eighteen years of experience with SQL Server and for past ten years he has been working on Azure. He is an Microsoft certified trainer. He also trains and is a consultant for SQL Server. Prior to this he has worked with Packt and written books on "Getting Started SQL Server 2014 Administration" , "Microsoft Azure laaS Essentials", and Professional Azure SQL Database Administration.
Read more about Gethyn Ellis