Delayed Durability–I start to like it!

Posted by Michael Zilberstein on SQL Blog See other posts from SQL Blog or by Michael Zilberstein
Published on Tue, 05 Nov 2013 14:51:17 GMT Indexed on 2013/11/05 16:04 UTC
Read the original article Hit count: 365

Filed under:

Delayed Durability

|

internals

|

Performance

|

SQL2014

|

Transaction log

In my previous post about the subject I’ve complained that according to BOL , this feature is enabled for Hekaton only. Panagiotis Antonopoulos from Microsoft commented that actually BOL is wrong – delayed durability can be used with all sorts of transactions, not just In-Memory ones. There is a database-level setting for delayed durability: default value is “Disabled”, other two options are “Allowed” and “Forced”. We’ll switch between “Disabled” and “Forced” and measure IO generated by a simple...(read more)

© SQL Blog or respective owner

Related posts about Delayed Durability

Durability of Websockets Server

as seen on Server Fault - Search for 'Server Fault'
I am starting to experiment with websockets. Does anyone know of a websockets server (open source or paid) that provides a durable store of the websocket "channel"? All of the examples that I have found do not address durability -- if a websockets server goes down, all "channel" data is lost. Services… >>> More
delayed job problem in rails.

as seen on Stack Overflow - Search for 'Stack Overflow'
My controller data_files_controller.rb def upload_balances DataFile.load_balances(params) end My model data_file.rb def self.load_balances(params) # Pull the file out of the http request, write it to file system name = params['Filename'] directory = "public/uploads" errors_table_name = "snapshot_errors" upload_file… >>> More
SQL Server 2014 – delayed transaction durability

as seen on SQL Blog - Search for 'SQL Blog'
As I’m downloading SQL Server 2014 CTP2 at this very moment, I’ve noticed new fascinating feature that hadn’t been announced in CTP1 : delayed transaction durability . It means that if your system is heavy on writes and on another hand you can tolerate data loss on some rare occasions – you can consider… >>> More
Resulting .exe from PyInstaller with wxPython crashing

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to compile a very simple wxPython script into an executable by using PyInstaller on Windows Vista. The Python script is nothing but a Hello World in wxPython. I'm trying to get that up and running as a Windows executable before I add any of the features that the program needs to have.… >>> More
SQLite3, "ALTER TABLE" and durability

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to run some ALTER TABLE statements on a sqlite3 database. What happens if the user kills the process or the power is cut while the ALTER TABLE is running? Will the database be left in a corrupt intermediate state? >>> More

Related posts about internals

SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting

as seen on SQL Authority - Search for 'SQL Authority'
Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort Link to Amazon (Worldwide) Link to Flipkart (India) Brief Review: Having a book on internal and associating that with real life is “almost” an impossible task… >>> More
New Webcast - SQL Server Internals & Architecture

as seen on SQL Blog - Search for 'SQL Blog'
Join me tomorrow for the PASS DBA Virtual Chapter meeting SQL Server Internals & Architecture (or view the archive). It's the most fun you'll ever have learning about the inner workings of a relational database - I promise!...(read more) >>> More
SQLAuthority Book Review Professional SQL Server 2008 Internals and Troubleshooting

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven WortLink to Amazon (Worldwide)Link to Flipkart (India)Brief Review: Having a book on internal and associating that with real life is almost an impossible task. The… >>> More
Bob Dorr’s SQL I/O Presentation on PSS Blog

as seen on SQL Blog - Search for 'SQL Blog'
In case you missed it, Bob Dorr from the PSS Team posted an amazing blog post today yesterday with all of the slides and speaker notes from his SQL Server I/O presentation. This is a must read for and Database Professional using SQL Server. http://blogs.msdn.com/psssql/archive/2010/03/24/how-it-works-bob-dorr-s-sql-server-i-o-presentation… >>> More
Bob Dorr’s SQL I/O Presentation on PSS Blog

as seen on SQL Blog - Search for 'SQL Blog'
In case you missed it, Bob Dorr from the PSS Team posted an amazing blog post today yesterday with all of the slides and speaker notes from his SQL Server I/O presentation. This is a must read for and Database Professional using SQL Server. http://blogs.msdn.com/psssql/archive/2010/03/24/how-it-works-bob-dorr-s-sql-server-i-o-presentation… >>> More