{"id":3584,"date":"2014-02-13T12:59:00","date_gmt":"2014-02-13T11:59:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/"},"modified":"2014-02-13T12:59:00","modified_gmt":"2014-02-13T11:59:00","slug":"delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/","title":{"rendered":"Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg\" alt=\"\" \/><\/p>\n<p>Delayed Transaction Durability is a new SQL Server 2014 feature that was not included in SQl Server 2014 CTP1 but discreetly published in CTP2. It is a very interesting functionality that helps reducing the IO contention for transaction log writes.<\/p>\n<p>In other databases engine, you will find equivalents such as:<\/p>\n<ul>\n<li>Oracle: &#8216;COMMIT WRITE BATCH WAIT|NOWAIT&#8217; (link <a href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/server.112\/e26088\/statements_4010.htm#SQLRF53776\">here<\/a>)<\/li>\n<li>MySQL: &#8216;group_commit&#8217; since version 4.x (link <a href=\"https:\/\/dev.mysql.com\/doc\/innodb\/1.1\/en\/innodb-performance-group_commit.html\">here<\/a>)<\/li>\n<li>PostgreSQL: &#8216;group_commit&#8217; introduce in version 9.2 (link <a href=\"http:\/\/wiki.postgresql.org\/wiki\/Group_commit\">here<\/a>)<\/li>\n<\/ul>\n<h3>What is it for?<\/h3>\n<p>It is very simple: &#8216;Delayed Transaction Durability&#8217; helps reducing the IO contention for transaction log writes. Transaction commits are asynchronous. The most important advantage is to release faster locks, but you have to consider that data can be lost (;-))&#8230;<\/p>\n<h3><\/h3>\n<h3>Full or Delayed Transaction Durability<\/h3>\n<p>What kind of Transaction Durability should you choose &#8211; full or delayed? This is not an easy topic:<\/p>\n<table style=\"border: 1px solid #000000;\" border=\"1\">\n<tbody>\n<tr>\n<td><strong>Transaction durability<\/strong><\/td>\n<td><strong>Explanation<\/strong><\/td>\n<td><strong>Advantage<\/strong><\/td>\n<td><strong>Disadvantage<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Full<\/td>\n<td>transactions are written in the transaction log to disk before returning control to the client<\/td>\n<td>No data loss<\/td>\n<td>IO contention during log writes<\/td>\n<\/tr>\n<tr>\n<td>Delayed<\/td>\n<td>transactions are written in the transaction log to disk after returning control to the client<\/td>\n<td>reduces IO contention<\/td>\n<td>Data loss possible<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>The best way to apply Transaction Durability maybe consists in mixing both types&#8230;<br \/>\nThis feature is not available for In-Memory OLTP transaction but only for regular transaction.<\/p>\n<h3>How to use it?<\/h3>\n<p>This option is available in 3 control levels:<\/p>\n<ul>\n<li>Database<\/li>\n<li>Atomic block in Natively Compiled Procedure<\/li>\n<li>COMMIT command option in T-SQL<\/li>\n<\/ul>\n<h4>Database level control<\/h4>\n<p>You can set this option with SSMS GUI or directly by script.<br \/>\nGUI: Right-click on database &gt; properties &gt; options -:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Delayed-durability.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Delayed-durability.png\"><img decoding=\"async\" title=\"Delayed-durability.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/Delayed-durability.png\" alt=\"Delayed-durability.png\" \/><\/a><\/p>\n<h4>Script:<\/h4>\n<p><samp>ALTER DATABASESET DELAYED_DURABILITY = {DISABLED (default) | ALLOWED | FORCED}<\/samp><\/p>\n<p>To insure backward compatibility, this option is set on DISABLED by default.<\/p>\n<p>Three\u00a0setting options are available:<\/p>\n<ul>\n<li>DISABLED: feature cannot be used<\/li>\n<li>ALLOWED: each transaction controls its durability (default is OFF for Atomic block in Natively Compiled Procedure and COMMIT command option in T-SQL)<\/li>\n<li>FORCED: every transaction is under delayed durability (might be dangerous)<\/li>\n<\/ul>\n<h4>Atomic block in Natively Compiled Procedure level control<\/h4>\n<p>In the creation of the stored procedure, it is just the option DELAYED_DURABILITY with ON or OFF like this sample:<\/p>\n<p><samp>CREATE PROCEDURE<\/samp><samp><\/samp><samp>WITH NATIVE_COMPILATION, SCHEMABINDING, EXECUTE AS OWNER<\/samp><samp><\/samp><samp>AS<\/samp><samp><\/samp><samp><\/samp><samp><\/samp><samp>BEGIN ATOMIC<\/samp><samp><\/samp><samp>WITH<\/samp><samp><\/samp><samp>(<\/samp><samp><\/samp><samp>\u00a0\u00a0\u00a0 DELAYED_DURABILITY = ON,<\/samp><samp><\/samp><samp>\u00a0\u00a0\u00a0 TRANSACTION ISOLATION LEVEL = SNAPSHOT, &#8230;.<\/samp><samp><\/samp><samp>) END<\/samp><samp><\/samp><samp><\/samp><samp><\/samp><\/p>\n<h4><\/h4>\n<h4>COMMIT command option in T-SQL level control<\/h4>\n<p>In the same way as for the Atomic Block in Natively Compiled Procedure, the COMMIT command has the option to set DELAYED_DURABILITY ON or OFF.<\/p>\n<h3>Conclusion<\/h3>\n<p>Delayed Transaction Durability is a new feature in SQL Server 2014, but given the feedback from my colleagues concerning other database systems (thanks a lot!), I would advise to use it with caution.<br \/>\nData loss is a risk for many applications and the data consistency is not granted, but in most case, you should have no problem.<br \/>\nA good example is a (very, very good) application inserting a lot of data and for each INSERT line a COMMIT is done&#8230;<br \/>\nDon&#8217;t smile, it&#8217;s a common use case!<\/p>\n<p>It is very practical in this case to have this option available in order to insure a fast workload.<br \/>\nI hope this will help you find the right answers and encourage you evaluating SQL Server 2014 CPT2 in order to resolve IO contention problems. SQL Server 2014 CTP2 is downloadable <a href=\"http:\/\/www.microsoft.com\/en-us\/sqlserver\/sql-server-2014.aspx\">here<\/a>.<br \/>\nFor more information on Delayed Transaction Durability, look up the msdn website <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/dn449490(v=sql.120).aspx\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Delayed Transaction Durability is a new SQL Server 2014 feature that was not included in SQl Server 2014 CTP1 but discreetly published in CTP2. It is a very interesting functionality that helps reducing the IO contention for transaction log writes. In other databases engine, you will find equivalents such as: Oracle: &#8216;COMMIT WRITE BATCH WAIT|NOWAIT&#8217;&hellip;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":3585,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4134],"tags":[49,51,52],"class_list":["post-3584","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-server","tag-microsoft","tag-sql-server","tag-sql-server-2014"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2 - dbi services | Blog<\/title>\n<meta name=\"description\" content=\"A new feature appears in the CPT2 from SQL Server 2014: Delayed Transaction Durability. It is a very interesting functionality that helps reducing the IO contention for transaction log writes. Discover this new feature in this blog...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2\" \/>\n<meta property=\"og:description\" content=\"A new feature appears in the CPT2 from SQL Server 2014: Delayed Transaction Durability. It is a very interesting functionality that helps reducing the IO contention for transaction log writes. Discover this new feature in this blog...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2014-02-13T11:59:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"100\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2\",\"datePublished\":\"2014-02-13T11:59:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/\"},\"wordCount\":571,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"SQL Server 2014\"],\"articleSection\":[\"Application Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/\",\"name\":\"Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2 - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg\",\"datePublished\":\"2014-02-13T11:59:00+00:00\",\"description\":\"A new feature appears in the CPT2 from SQL Server 2014: Delayed Transaction Durability. It is a very interesting functionality that helps reducing the IO contention for transaction log writes. Discover this new feature in this blog...\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg\",\"width\":200,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2 - dbi services | Blog","description":"A new feature appears in the CPT2 from SQL Server 2014: Delayed Transaction Durability. It is a very interesting functionality that helps reducing the IO contention for transaction log writes. Discover this new feature in this blog...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/","og_locale":"en_US","og_type":"article","og_title":"Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2","og_description":"A new feature appears in the CPT2 from SQL Server 2014: Delayed Transaction Durability. It is a very interesting functionality that helps reducing the IO contention for transaction log writes. Discover this new feature in this blog...","og_url":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2014-02-13T11:59:00+00:00","og_image":[{"width":200,"height":100,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2","datePublished":"2014-02-13T11:59:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/"},"wordCount":571,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg","keywords":["Microsoft","SQL Server","SQL Server 2014"],"articleSection":["Application Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/","url":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/","name":"Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2 - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg","datePublished":"2014-02-13T11:59:00+00:00","description":"A new feature appears in the CPT2 from SQL Server 2014: Delayed Transaction Durability. It is a very interesting functionality that helps reducing the IO contention for transaction log writes. Discover this new feature in this blog...","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg","width":200,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/delayed-transaction-durability-a-new-feature-in-sql-server-2014-ctp2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3584"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3584\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3585"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}