{"id":48585,"date":"2026-11-17T07:36:00","date_gmt":"2026-11-17T06:36:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=48585"},"modified":"2026-11-17T09:39:55","modified_gmt":"2026-11-17T08:39:55","slug":"sql-server-how-many-row-versions-does-an-rcsi-read-walk","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/","title":{"rendered":"SQL Server: How many row versions does an RCSI read walk?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A <code>SELECT SUM(v)<\/code> over a 10,000-row table, under RCSI in Azure SQL Database, with STATISTICS IO on:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nTable &#039;&#x5B;dbo].&#x5B;t]&#039;. Scan count 1, logical reads 330, physical reads 0, ...\nObject &#039;&#x5B;dbo].&#x5B;t]&#039;. Tempdb versions read 0, in-row PVS versions read 10000, off-row PVS versions read 210000, online index PVS versions read 0.\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">The <code>Table<\/code> line looks like a normal scan of 330 pages. The <code>Object<\/code> line says the read walked through 220,000 row versions, 22 per row, because another session had updated these rows 22 times in a transaction it had not committed yet. The same read took about 117 ms of CPU, against 3 ms when nothing was pending.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The <code>Object<\/code> line is new. It comes from the version store read metrics <a href=\"https:\/\/www.linkedin.com\/in\/dimitri-furman-200a555\/\" data-type=\"link\" data-id=\"https:\/\/www.linkedin.com\/in\/dimitri-furman-200a555\/\">Dimitri Furman<\/a> announced on <a href=\"https:\/\/techcommunity.microsoft.com\/blog\/azuresqlblog\/closing-a-monitoring-blind-spot-version-store-read-metrics\/4571741\">the Azure SQL blog last week<\/a>, which also appear in the actual plan XML returned by the server (SSMS 22.12.0 drops them, both in the graphical plan and in Show Execution Plan XML; copy the XML cell from <code>SET STATISTICS XML ON<\/code> to see them), in four extended events, in <code>sys.dm_exec_query_stats<\/code> and its procedure, trigger and function counterparts, and in <code>sys.dm_exec_requests<\/code> and <code>sys.dm_exec_sessions<\/code> (<a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/sql-server-transaction-locking-and-row-versioning-guide?view=sql-server-ver17\" data-type=\"link\" data-id=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/sql-server-transaction-locking-and-row-versioning-guide?view=sql-server-ver17\">Microsoft documentation<\/a>). For now they exist in Azure SQL Database and SQL database in Microsoft Fabric; Managed Instance and the next SQL Server version are announced to follow.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When I recommend RCSI, the usual worry is the open transaction someone forgot in SSMS. These metrics let me check what it actually costs the readers.<\/p>\n\n\n\n<h2 id=\"h-setup\" class=\"wp-block-heading\">Setup<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Azure SQL Database, General Purpose serverless (GP_S_Gen5_2, up to 2 vCores), where ADR and RCSI are always on. One table of 10,000 narrow rows (166 pages):<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE dbo.t\n(\n    id     int       NOT NULL PRIMARY KEY,\n    v      int       NOT NULL,\n    filler char(100) NOT NULL DEFAULT &#039;x&#039;\n);\nINSERT dbo.t (id, v)\nSELECT TOP (10000) ROW_NUMBER() OVER (ORDER BY (SELECT NULL)), 0\nFROM sys.all_objects a CROSS JOIN sys.all_objects b;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">A reader runs <code>SELECT SUM(v) FROM dbo.t<\/code> every 2 seconds under the default isolation level. I measure each read by taking <code>version_reads<\/code>, <code>logical_reads<\/code> and <code>cpu_time<\/code> from <code>sys.dm_exec_requests<\/code> for the current session just before and just after the <code>SELECT<\/code>.<\/p>\n\n\n\n<h2 id=\"h-case-1-the-open-transaction-does-not-touch-the-rows\" class=\"wp-block-heading\">Case 1: the open transaction does not touch the rows<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The forgotten session updates one row in an unrelated table and goes idle:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBEGIN TRANSACTION;\nUPDATE dbo.dummy SET x = 1;\n-- left open\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Meanwhile a writer updates every row of <code>dbo.t<\/code> 30 times, committing each update, and the reader reads after each one. I ran it once without the forgotten session and once with it:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Forgotten session<\/th><th>Max version reads per read<\/th><th>Logical reads per read<\/th><th>Avg CPU per read<\/th><\/tr><\/thead><tbody><tr><td>no<\/td><td>0<\/td><td>329 to 330<\/td><td>2.7 ms<\/td><\/tr><tr><td>yes<\/td><td>0<\/td><td>329<\/td><td>2.8 ms<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The forgotten session did freeze version cleanup. In a separate run with the same 30 updates, I logged <code>sys.dm_tran_persistent_version_store_stats<\/code> every few seconds. Without the dormant session, the persistent version store (PVS) went back down from <strong>43,784 KB to 9,160 KB about 20 seconds<\/strong> after the last update. With it, <code>oldest_active_transaction_id<\/code> went from 0 to a non-zero value and the PVS stayed at 74,696 KB for 110 seconds of idle time, until the <code>ROLLBACK<\/code>; about 45 seconds later it was down to 16,520 KB.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The version chains behind each row kept growing, and the reader ignored them. RCSI needs the last version committed before the statement started, and after a committed update that is the row on the page.<\/p>\n\n\n\n<h2 id=\"h-case-2-the-open-transaction-updates-the-rows-being-read\" class=\"wp-block-heading\">Case 2: the open transaction updates the rows being read<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Now the forgotten session updates the rows the reader reads, 30 times, and never commits:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBEGIN TRANSACTION;\nUPDATE dbo.t SET v = v + 1;   -- repeated 30 times, 2 seconds apart\n-- no COMMIT\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11-1024x576.png\" alt=\"\" class=\"wp-image-48595\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11-1024x576.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11-300x169.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11-768x432.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11.png 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The reader cannot use the row on the page any more, because its value is not committed, so it walks back to the last committed version. Each uncommitted update adds exactly one version per row to that walk: 10,000 version reads after the first update, 300,000 after the thirtieth.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The first one is cheap. That version was stored in-row, so the read cost 164 extra logical reads (the rows got wider) and went from 3 to 6 ms of CPU. Every later update pushed one more version off-row, each costing a page read: logical reads went up by exactly 10,000 per update, and CPU grew linearly at 0.54 ms per 1,000 versions <strong>(a figure for this test only: it will vary with the size of the modified data and the service tier)<\/strong>. After 30 updates the same read took 167 ms instead of 3.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In my other run of this test, the first version went off-row immediately and cost 10,000 page reads from the start. Counting the snapshot runs mentioned below, the first version was in-row in three runs out of four, so in-row is frequent, not guaranteed.<\/p>\n\n\n\n<h2 id=\"h-what-this-means-for-rcsi\" class=\"wp-block-heading\">What this means for RCSI<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Case 2 is a worst case on purpose: one transaction updating every row of the table 30 times without committing, while readers scan all of it. In the OLTP workloads I work on, a transaction usually changes a given row only once, so an RCSI read walks zero versions on committed rows and one on a row someone is still changing. That single version was in-row, and cheap, in three of my four runs; off-row, it costs one page read per row. The walk gets longer only when the same row changes many times within one transaction, or, by the same rule, many times during one long-running statement that reads it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Snapshot isolation is a different story, and it is less common in the workloads I see. A snapshot transaction reads the database as of its start, so every committed change since then is one more version to walk. In a separate test with the same table, a snapshot transaction rereading it while 30 updates were committed elsewhere walked one version per row per update, 300,000 in the end, at a similar CPU cost per version.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A forgotten transaction that only touched other tables costs PVS space and leaves RCSI readers alone.<\/p>\n\n\n\n<h2 id=\"h-what-was-already-known\" class=\"wp-block-heading\">What was already known<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">None of this mechanism is new: Sunil Agarwal described <a href=\"https:\/\/techcommunity.microsoft.com\/blog\/sqlserver\/overhead-of-row-versioning\/383379\">the cost of walking version chains in 2008<\/a>, and Josh Darnell and Forrest McDaniel showed in 2019 <a href=\"https:\/\/dba.stackexchange.com\/questions\/237704\/does-statistics-io-output-include-version-store-reads\" data-type=\"link\" data-id=\"https:\/\/dba.stackexchange.com\/questions\/237704\/does-statistics-io-output-include-version-store-reads\">that STATISTICS IO does not count version store reads<\/a>, which still holds with the PVS (330 logical reads on the <code>Table<\/code> line, 210,330 in <code>sys.dm_exec_requests<\/code> for the read at the top). What the new metrics add is a direct count per query.<\/p>\n\n\n\n<h2 id=\"h-queries-to-keep\" class=\"wp-block-heading\">Queries to keep<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Which cached statements pay for versions:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT TOP (10)\n       qs.total_version_reads,\n       qs.execution_count,\n       qs.total_logical_reads,\n       qs.total_worker_time,\n       SUBSTRING(st.text, qs.statement_start_offset \/ 2 + 1,\n                 (CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(st.text)\n                       ELSE qs.statement_end_offset END - qs.statement_start_offset) \/ 2 + 1) AS statement_text\nFROM sys.dm_exec_query_stats AS qs\nCROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st\nORDER BY qs.total_version_reads DESC;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Whether something is holding version cleanup:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT persistent_version_store_size_kb, oldest_active_transaction_id\nFROM sys.dm_tran_persistent_version_store_stats\nWHERE database_id = DB_ID();\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">If version reads are high on a few statements, look for a transaction that keeps modifying the rows they read, or for a long snapshot transaction. If the PVS grows while version reads stay near zero, the cost is storage and your readers are fine for now.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.linkedin.com\/in\/dimitri-furman-200a555\/\" data-type=\"link\" data-id=\"https:\/\/www.linkedin.com\/in\/dimitri-furman-200a555\/\">Dimitri Furman<\/a> asks whether version reads should be added to Query Store. I would like to see them there: a growing version walk is the kind of drift you only notice in history.<\/p>\n\n\n\n<h2 id=\"h-reproducing-it\" class=\"wp-block-heading\">Reproducing it<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Two sessions on the same Azure SQL Database (GP_S_Gen5_2, November 2026, default settings), the table from the setup above, recreated before each test. Each read is measured like this:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT @vr0 = version_reads, @lr0 = logical_reads, @cpu0 = cpu_time\nFROM sys.dm_exec_requests WHERE session_id = @@SPID;\n\nSELECT @s = SUM(v) FROM dbo.t OPTION (MAXDOP 1);\n\nSELECT version_reads - @vr0, logical_reads - @lr0, cpu_time - @cpu0\nFROM sys.dm_exec_requests WHERE session_id = @@SPID;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">The rest is loops: 30 updates of every row 2 seconds apart (committed in case 1, inside the open transaction in case 2), one measured read after each, and <code>sys.dm_tran_persistent_version_store_stats<\/code> polled every few seconds for the PVS size.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How many row versions does an RCSI read walk when a transaction stays open? Measured with the new Azure SQL version read metrics.<\/p>\n","protected":false},"author":157,"featured_media":0,"comment_status":"open","ping_status":"closed","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":[99],"tags":[],"class_list":["post-48585","post","type-post","status-publish","format-standard","category-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server: How many row versions does an RCSI read walk? - dbi services Blog<\/title>\n<meta name=\"description\" content=\"How many row versions does an RCSI read walk when a transaction stays open? Measured with the new Azure SQL version read metrics.\" \/>\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-how-many-row-versions-does-an-rcsi-read-walk\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: How many row versions does an RCSI read walk?\" \/>\n<meta property=\"og:description\" content=\"How many row versions does an RCSI read walk when a transaction stays open? Measured with the new Azure SQL version read metrics.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/\" \/>\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=\"2026-11-17T06:36:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-17T08:39:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Louis Tochon\" \/>\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=\"Louis Tochon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 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-how-many-row-versions-does-an-rcsi-read-walk\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/\"},\"author\":{\"name\":\"Louis Tochon\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/f346aec2e39387f71c1c2ceab92cc549\"},\"headline\":\"SQL Server: How many row versions does an RCSI read walk?\",\"datePublished\":\"2026-11-17T06:36:00+00:00\",\"dateModified\":\"2026-11-17T08:39:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/\"},\"wordCount\":1061,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/image-11-1024x576.png\",\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/\",\"name\":\"SQL Server: How many row versions does an RCSI read walk? - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/image-11-1024x576.png\",\"datePublished\":\"2026-11-17T06:36:00+00:00\",\"dateModified\":\"2026-11-17T08:39:55+00:00\",\"description\":\"How many row versions does an RCSI read walk when a transaction stays open? Measured with the new Azure SQL version read metrics.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/image-11.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/image-11.png\",\"width\":1200,\"height\":675},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: How many row versions does an RCSI read walk?\"}]},{\"@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\\\/#organization\"},\"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\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"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 specialized 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\\\/f346aec2e39387f71c1c2ceab92cc549\",\"name\":\"Louis Tochon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/LTO_WEB.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/LTO_WEB.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/LTO_WEB.jpg\",\"caption\":\"Louis Tochon\"},\"description\":\"Louis Tochon specializes in SQL Server and Oracle database administration, with expertise in performance optimization, scripting, backup\\\/restore, and high availability (Always-On). He is Microsoft Certified Azure Database Administrator Associate. He completed a master's thesis in cybersecurity at SICPA and worked as a SQL Server and Oracle DBA for almost two years at Lombard-Odier. Louis holds a Master's degree in Information Systems from HEC Lausanne. His industry experience covers mainly the banking sector.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/louis-tochon\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server: How many row versions does an RCSI read walk? - dbi services Blog","description":"How many row versions does an RCSI read walk when a transaction stays open? Measured with the new Azure SQL version read metrics.","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-how-many-row-versions-does-an-rcsi-read-walk\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: How many row versions does an RCSI read walk?","og_description":"How many row versions does an RCSI read walk when a transaction stays open? Measured with the new Azure SQL version read metrics.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2026-11-17T06:36:00+00:00","article_modified_time":"2026-11-17T08:39:55+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11.png","type":"image\/png"}],"author":"Louis Tochon","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Louis Tochon","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/"},"author":{"name":"Louis Tochon","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/f346aec2e39387f71c1c2ceab92cc549"},"headline":"SQL Server: How many row versions does an RCSI read walk?","datePublished":"2026-11-17T06:36:00+00:00","dateModified":"2026-11-17T08:39:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/"},"wordCount":1061,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11-1024x576.png","articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/","name":"SQL Server: How many row versions does an RCSI read walk? - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11-1024x576.png","datePublished":"2026-11-17T06:36:00+00:00","dateModified":"2026-11-17T08:39:55+00:00","description":"How many row versions does an RCSI read walk when a transaction stays open? Measured with the new Azure SQL version read metrics.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/image-11.png","width":1200,"height":675},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-many-row-versions-does-an-rcsi-read-walk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: How many row versions does an RCSI read walk?"}]},{"@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\/#organization"},"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\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","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 specialized 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\/f346aec2e39387f71c1c2ceab92cc549","name":"Louis Tochon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/11\/LTO_WEB.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/11\/LTO_WEB.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/11\/LTO_WEB.jpg","caption":"Louis Tochon"},"description":"Louis Tochon specializes in SQL Server and Oracle database administration, with expertise in performance optimization, scripting, backup\/restore, and high availability (Always-On). He is Microsoft Certified Azure Database Administrator Associate. He completed a master's thesis in cybersecurity at SICPA and worked as a SQL Server and Oracle DBA for almost two years at Lombard-Odier. Louis holds a Master's degree in Information Systems from HEC Lausanne. His industry experience covers mainly the banking sector.","url":"https:\/\/www.dbi-services.com\/blog\/author\/louis-tochon\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48585","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\/157"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=48585"}],"version-history":[{"count":16,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48585\/revisions"}],"predecessor-version":[{"id":48652,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48585\/revisions\/48652"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=48585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=48585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=48585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}