{"id":38929,"date":"2025-05-26T15:08:25","date_gmt":"2025-05-26T13:08:25","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=38929"},"modified":"2025-06-06T15:41:33","modified_gmt":"2025-06-06T13:41:33","slug":"sql-server-2025-ag-commit-time","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/","title":{"rendered":"SQL Server 2025 &#8211; AG Commit Time"},"content":{"rendered":"\n<p>SQL Server 2025 preview has been publicly available for a week now: you can find all the details in this blog &#8220;<a href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-public-preview-and-ssms-21-now-available\/\">SQL Server 2025 Public Preview and SSMS 21 now available<\/a>&#8220;.<br>In this blog, I want to make an highlight on one Engine High Availability (HA) feature: <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/configure-windows\/availability-group-commit-time-server-configuration-options?view=sql-server-ver17\">Availability Group Commit Time<\/a>.<\/p>\n\n\n\n<p>For a little background, Always On Availability Group (AG) is a feature released in SQL Server 2012.<br>This HA technology has benefited from numerous improvements over time, and most notably in SQL Server 2016 (automatic seeding, read-only replicas, dtc support, database health detection, distributed AG&#8230;).<br>To address a performance issue, SQL Server 2016 has introduced AG Commit Time. For nodes in synchronous mode, this concept reduces latency by specifying the time after which a transaction must be sent to the replicas.<br>If this value is not respected, it helps identifying possible bottlenecks between primary and secondary replicas: it improves <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/monitor-performance-for-always-on-availability-groups?view=sql-server-ver16&amp;tabs=new-limits#calculation-of-secondary-database-rpo\">monitoring and troubleshooting<\/a>.<\/p>\n\n\n\n<p>In some specific scenarios, this default value may not correspond business requirements when 10 ms delay (default value) is too high. As a result, SQL Server 2025 makes this value configurable through server configuration (<em>availability group commit time<\/em>).<br>Let&#8217;s look at how to change the configuration, and more interestingly, how to measure the impact of the new value.<\/p>\n\n\n\n<p> After downloading the latest version SQL Server Management Studio (SSMS) &#8211; <a href=\"https:\/\/learn.microsoft.com\/ssms\/install\/install\">release 21<\/a> &#8211; let&#8217;s connect to the Primary node. Here is my AG configuration (2 replicas + a fileshare witness):<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"508\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration-1024x508.png\" alt=\"\" class=\"wp-image-38941\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration-1024x508.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration-300x149.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration-768x381.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration.png 1255w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>As announced slightly before, this value is configurable at instance level:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT name, value, value_in_use, is_advanced, is_dynamic\nFROM sys.configurations WHERE name = 'availability group commit time (ms)'<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1183\" height=\"185\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/Configurations.png\" alt=\"\" class=\"wp-image-38946\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/Configurations.png 1183w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/Configurations-300x47.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/Configurations-1024x160.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/Configurations-768x120.png 768w\" sizes=\"auto, (max-width: 1183px) 100vw, 1183px\" \/><\/figure>\n\n\n\n<p>0 means default value is used: 10ms. To change this default value &#8211; let&#8217;s say 1 ms for the example &#8211; it can be done through the stored procedure <em>sp_configure<\/em>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>EXEC sp_configure 'show advanced options', '1';\nRECONFIGURE;\n\nEXEC sp_configure 'availability group commit time (ms)', '0'\nRECONFIGURE;\n\nEXEC sp_configure 'show advanced options', '0';\nRECONFIGURE;\n\nSELECT name, value, value_in_use, is_advanced, is_dynamic FROM sys.configurations\nWHERE name = 'availability group commit time (ms)'<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1286\" height=\"478\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/Availability-Grroup-Commit-Time3.png\" alt=\"\" class=\"wp-image-38942\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/Availability-Grroup-Commit-Time3.png 1286w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/Availability-Grroup-Commit-Time3-300x112.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/Availability-Grroup-Commit-Time3-1024x381.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/Availability-Grroup-Commit-Time3-768x285.png 768w\" sizes=\"auto, (max-width: 1286px) 100vw, 1286px\" \/><\/figure>\n\n\n\n<p>It is possible to use the DMV sys.dm_hadr_database_replica_states to get an idea of the AG commit time between Primary and Secondary:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \n    database_id,\n    is_primary_replica,\n    synchronization_state_desc,\n    last_commit_time,\n    last_hardened_time,\n    last_received_time,\n    last_sent_time\nFROM sys.dm_hadr_database_replica_states;\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"885\" height=\"415\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/dmv.png\" alt=\"\" class=\"wp-image-38947\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/dmv.png 885w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/dmv-300x141.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/dmv-768x360.png 768w\" sizes=\"auto, (max-width: 885px) 100vw, 885px\" \/><\/figure>\n\n\n\n<p>It is also possible to calculate the time between the hard_log_block is sent, and when the hard_receive_harden_lsn_message is received on the Primary.<br>To do so, let&#8217;s set up an Extended Events (XE) session:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\nCREATE EVENT SESSION &#91;AG_Commit_Latency_Tracking] ON SERVER\nADD EVENT sqlserver.hadr_log_block_send_complete(\n&nbsp;&nbsp;&nbsp; ACTION(sqlserver.sql_text)\n),\nADD EVENT sqlserver.hadr_receive_harden_lsn_message(\n&nbsp;&nbsp;&nbsp; ACTION(sqlserver.sql_text)\n),\nADD EVENT sqlserver.hadr_log_block_group_commit(\n&nbsp;&nbsp;&nbsp; ACTION(sqlserver.sql_text)\n)\nADD TARGET package0.event_file (\n&nbsp;&nbsp;&nbsp; SET filename = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL17.MSSQLSERVER\\MSSQL\\Log\\AG_Commit_Latency.xel', max_file_size = 50, max_rollover_files = 5\n\n)\nWITH (STARTUP_STATE = ON);\nGO\n\nALTER EVENT SESSION &#91;AG_Commit_Latency_Tracking] ON SERVER STATE = START;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \n&nbsp;&nbsp;&nbsp; event_data.value('(event\/@name)&#91;1]', 'varchar(100)') AS event_name,\n&nbsp;&nbsp;&nbsp; event_data.value('(event\/@timestamp)&#91;1]', 'datetime2') AS &#91;timestamp],\n&nbsp;&nbsp;&nbsp; event_data.value('(event\/action&#91;@name=\"sql_text\"]\/value)&#91;1]', 'nvarchar(max)') AS sql_text\nFROM \n(\n&nbsp;&nbsp;&nbsp; SELECT CAST(event_data AS XML) AS event_data\n&nbsp;&nbsp;&nbsp; FROM sys.fn_xe_file_target_read_file('C:\\Program Files\\Microsoft SQL Server\\MSSQL17.MSSQLSERVER\\MSSQL\\Log\\AG_Commit_Latency*.xel', NULL, NULL, NULL)\n) AS events\nORDER BY &#91;timestamp] DESC;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"665\" height=\"60\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/XE.png\" alt=\"\" class=\"wp-image-38950\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/XE.png 665w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/XE-300x27.png 300w\" sizes=\"auto, (max-width: 665px) 100vw, 665px\" \/><\/figure>\n\n\n\n<p>As both events are gathered on the Primary, the message received does not match exactly the time the secondary processed the message, but it gives a good idea if the duration is respected.<\/p>\n\n\n\n<p>Keep in mind the default value (10 ms) is suitable for most workloads, as it is a good balance between performance and efficiency.<br>On the other hand, a lower value may just unbalance the load distribution on the primary, forcing it to synchronize more often than required; and it will benefit less from log block compression on the network.<br><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server 2025 preview has been publicly available for a week now: you can find all the details in this blog &#8220;SQL Server 2025 Public Preview and SSMS 21 now available&#8220;.In this blog, I want to make an highlight on one Engine High Availability (HA) feature: Availability Group Commit Time. For a little background, Always [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,99],"tags":[51],"type_dbi":[],"class_list":["post-38929","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-sql-server","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2025 - AG Commit Time - dbi Blog<\/title>\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\/sql-server-2025-ag-commit-time\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2025 - AG Commit Time\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2025 preview has been publicly available for a week now: you can find all the details in this blog &#8220;SQL Server 2025 Public Preview and SSMS 21 now available&#8220;.In this blog, I want to make an highlight on one Engine High Availability (HA) feature: Availability Group Commit Time. For a little background, Always [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-26T13:08:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-06T13:41:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1255\" \/>\n\t<meta property=\"og:image:height\" content=\"623\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nathan Courtine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Courtine\" \/>\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\\\/sql-server-2025-ag-commit-time\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/\"},\"author\":{\"name\":\"Nathan Courtine\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"headline\":\"SQL Server 2025 &#8211; AG Commit Time\",\"datePublished\":\"2025-05-26T13:08:25+00:00\",\"dateModified\":\"2025-06-06T13:41:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/\"},\"wordCount\":437,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/AG-Configuration-1024x508.png\",\"keywords\":[\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/\",\"name\":\"SQL Server 2025 - AG Commit Time - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/AG-Configuration-1024x508.png\",\"datePublished\":\"2025-05-26T13:08:25+00:00\",\"dateModified\":\"2025-06-06T13:41:33+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/AG-Configuration.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/AG-Configuration.png\",\"width\":1255,\"height\":623},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2025-ag-commit-time\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2025 &#8211; AG Commit Time\"}]},{\"@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\\\/38305b5ebdcdb4fb784fa31d760862d1\",\"name\":\"Nathan Courtine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"caption\":\"Nathan Courtine\"},\"description\":\"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \\\/ Banking, etc.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/nathan-courtine\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2025 - AG Commit Time - dbi 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\/sql-server-2025-ag-commit-time\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2025 - AG Commit Time","og_description":"SQL Server 2025 preview has been publicly available for a week now: you can find all the details in this blog &#8220;SQL Server 2025 Public Preview and SSMS 21 now available&#8220;.In this blog, I want to make an highlight on one Engine High Availability (HA) feature: Availability Group Commit Time. For a little background, Always [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/","og_site_name":"dbi Blog","article_published_time":"2025-05-26T13:08:25+00:00","article_modified_time":"2025-06-06T13:41:33+00:00","og_image":[{"width":1255,"height":623,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration.png","type":"image\/png"}],"author":"Nathan Courtine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Courtine","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/"},"author":{"name":"Nathan Courtine","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"headline":"SQL Server 2025 &#8211; AG Commit Time","datePublished":"2025-05-26T13:08:25+00:00","dateModified":"2025-06-06T13:41:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/"},"wordCount":437,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration-1024x508.png","keywords":["SQL Server"],"articleSection":["Database Administration &amp; Monitoring","Database management","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/","name":"SQL Server 2025 - AG Commit Time - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration-1024x508.png","datePublished":"2025-05-26T13:08:25+00:00","dateModified":"2025-06-06T13:41:33+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2025\/05\/AG-Configuration.png","width":1255,"height":623},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2025-ag-commit-time\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2025 &#8211; AG Commit Time"}]},{"@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\/38305b5ebdcdb4fb784fa31d760862d1","name":"Nathan Courtine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","caption":"Nathan Courtine"},"description":"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38929","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=38929"}],"version-history":[{"count":19,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38929\/revisions"}],"predecessor-version":[{"id":39049,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38929\/revisions\/39049"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=38929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=38929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=38929"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=38929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}