{"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\/sites\/2\/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\/sites\/2\/2022\/04\/Delayed-durability.png\"><img decoding=\"async\" title=\"Delayed-durability.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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;]<\/p>\n","protected":false},"author":15,"featured_media":3585,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[49,51,52],"type_dbi":[],"class_list":["post-3584","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-integration-middleware","tag-microsoft","tag-sql-server","tag-sql-server-2014"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2 - dbi 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 Blog\" \/>\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\/sites\/2\/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: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\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"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,\"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\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"SQL Server 2014\"],\"articleSection\":[\"Application integration &amp; Middleware\"],\"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 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\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg\",\"datePublished\":\"2014-02-13T11:59:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"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\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/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 Blog\",\"description\":\"\",\"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\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"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 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 Blog","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\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","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\/d0bfb7484ae81c8980fc2b11334f803b"},"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,"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\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg","keywords":["Microsoft","SQL Server","SQL Server 2014"],"articleSection":["Application integration &amp; Middleware"],"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 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\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg","datePublished":"2014-02-13T11:59:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"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\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL_Server_2014_200x100.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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 Blog","description":"","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":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","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"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}