{"id":13586,"date":"2020-03-04T20:24:28","date_gmt":"2020-03-04T19:24:28","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/"},"modified":"2025-10-01T11:39:39","modified_gmt":"2025-10-01T09:39:39","slug":"sql-server-collect-page-split-events-using-extended-event-session","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/","title":{"rendered":"SQL Server: Collect Page Split events using Extended Event session"},"content":{"rendered":"<p>Earlier this week someone tried to show me how to capture page split events using Extended Events (XE) but unfortunately, the demo failed. This is a good opportunity for me to refresh my knowledge about page split and set up a simple demo about this. Hopefully, this one will be working.<\/p>\n<p>It\u2019s not necessarily a bad thing when a page split occurs. It\u2019s a totally fine behavior when we INSERT a row in a table with a clustered index (e.g.: column with identity property). SQL Server will create a page to the right-hand side of the index (at the leaf level). This event is a kind of page split; SPLIT_FOR_INSERT<\/p>\n<p>In this post, I will focus on the SPLIT_FOR_UPDATE page split which occurs when we UPDATE a row. The updated row size doesn\u2019t fit anymore in its current page. A new page is allocated by SQL Server, the row is moved to this new page before being written to disk and to the transaction log. Moreover, pages in all the index pointing to the data pages are updated. This type of page split can be problematic.<\/p>\n<p>Let\u2019s start this demo. I\u2019ll use the <a href=\"https:\/\/github.com\/microsoft\/sql-server-samples\/tree\/master\/samples\/databases\/wide-world-importers\">WildWorldImporters<\/a> database on SQL Server 2019.<\/p>\n<h3>The page_split Extended Event<\/h3>\n<p>The Extended Event page_split provides a splitOperation element. The value 3 stands for SPLIT_FOR_UPDATE.<br \/>\nThis event did not provide such detailed information before SQL Server 2012.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">CREATE EVENT SESSION [PageSplit] ON SERVER\nADD EVENT sqlserver.page_split(\n\u00a0\u00a0\u00a0 WHERE (\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [splitOperation]=\u00a0\u00a0 3\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND [database_id]=\u00a0 9\u00a0\u00a0\u00a0\u00a0\u00a0 -- Change to your database_id\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\n)\nADD TARGET package0.ring_buffer\nGO\nALTER EVENT SESSION [PageSplit] ON SERVER STATE=START;\nGO<\/pre>\n<h3>Page split demo<\/h3>\n<pre class=\"brush: sql; gutter: true\">EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE\nGO\nEXEC sys.sp_configure N'fill factor (%)', N'0' RECONFIGURE WITH OVERRIDE\nGO\nEXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH OVERRIDE\nGO\nuse WideWorldImporters\ngo\ncreate sequence Sequences.PageSplitOdd start with 1 INCREMENT by 2;\ncreate sequence Sequences.PageSplitEven start with 2 INCREMENT by 2;\n\ncreate table DemoPageSplit (\n    id int not null primary key,\n    col varchar(8000) null\n);<\/pre>\n<p>First, I make sure the Fill Factor is set to 100% (value 0) and for the sake of the demo I use sequences to insert only odd numbers in my primary key.<br \/>\nAn SQL Server page is 8KB. With this table structure, 2 rows can easily fit on the same page if the varchar column is not fully used.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">insert into DemoPageSplit(id, col)\n    select next value for [Sequences].PageSplitOdd, replicate('a', 4000)\ngo 10<\/pre>\n<p>I just inserted 10 rows with only 4000 bytes of data each for the varchar column.<br \/>\nLet\u2019s have a look at the clustered index leaf-level pages stats.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT index_type_desc, alloc_unit_type_desc, index_depth, avg_page_space_used_in_percent\n    , page_count, record_count, avg_record_size_in_bytes\nFROM sys.dm_db_index_physical_stats(\n    DB_ID('WideWorldImporters')\n    , OBJECT_ID('DemoPageSplit'), NULL, NULL , 'DETAILED')\nwhere index_level = 0 -- 0 for index leaf levels\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37776 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png\" alt=\"\" width=\"911\" height=\"56\" \/><\/p>\n<p>We can see 5 pages at the leaf-level of the index. Pages are almost 100% full and can fit 2 rows each as expected.<\/p>\n<p>I can now UPDATE one of the rows to trigger a page split.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">update DemoPageSplit set col = CONCAT(col, replicate('c', 1000)) where id = 5<\/pre>\n<p>The SPLIT_FOR_UPDATE event has been generated successfully.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-37780\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1B.png\" alt=\"\" width=\"300\" height=\"264\" \/><\/p>\n<p>Now, I run the previous query again about index stats, the result shows a new page has been created while the number of rows is still 10.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37778 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_2.png\" alt=\"\" width=\"948\" height=\"60\" \/><\/p>\n<h3>Querying the XE data with sys.dm_db_page_info<\/h3>\n<p>Using the new SQL Server 2019 DMV in a CROSS APPLY I can directly see in SQL some in-depth details about the pages changed by the page split.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">;with xe AS (\n    select\n        xed.event_data.value('(data[@name=\"database_id\"]\/value)[1]', 'int') as databaseId\n        , xed.event_data.value('(data[@name=\"file_id\"]\/value)[1]', 'int') as fileId\n        , xed.event_data.value('(data[@name=\"new_page_page_id\"]\/value)[1]', 'int') as new_page\n        , xed.event_data.value('(data[@name=\"page_id\"]\/value)[1]', 'int') as pageId\n        , xed.event_data.value('(data[@name=\"splitOperation\"]\/value)[1]', 'varchar') as SplitOperation\n    FROM (\n        SELECT CAST(target_data as XML) target_data\n        FROM sys.dm_xe_sessions AS s\n            JOIN sys.dm_xe_session_targets t\n                ON s.address = t.event_session_address\n        WHERE s.name = 'PageSplit'\n          AND t.target_name = 'ring_buffer' \n    ) as tab\n        CROSS APPLY target_data.nodes('RingBufferTarget\/event') as xed(event_data)\n)\nselect p.page_id, p.page_type_desc, p.free_bytes, p.free_bytes_offset\nfrom xe\n    cross apply sys.dm_db_page_info(\n        xe.databaseId, xe.fileId, xe.new_page, 'DETAILED'\n    ) AS p\nunion\nselect p.page_id, p.page_type_desc, p.free_bytes, p.free_bytes_offset\nfrom xe\n    cross apply sys.dm_db_page_info(\n       xe.databaseId, xe.fileId, xe.pageId, 'DETAILED'\n    ) AS p<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37786 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_3.png\" alt=\"\" width=\"416\" height=\"82\" \/><\/p>\n<p>The page with id 8114 has about 3KB of free space. It&#8217;s is the new page produced by the Page Split. The page 8118 contains the row we updated to a 4KB varchar.<br \/>\nIn addition to this demo, if you want to go further I suggest you remove the filter on splitOperation from the XE session and run the following batchs;<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">insert into DemoPageSplit(id, col)\n    select next value for [Sequences].PageSplitEven, replicate('a', 4000)\ngo 10\ninsert into DemoPageSplit(id, col)\n    select next value for [Sequences].PageSplitEven, replicate('a', 8000)\ngo 10<\/pre>\n<p>What kind of Page split operation is produced and what is the consequence on the index page count?<\/p>\n<p>In this blog post, we\u2019ve seen how to easily trigger a page split events of type UPDATE and capture them using an Extended Event Session. We saw that such XE session data can be used with the new DMV sys.dm_db_page_info.<\/p>\n<p>Written by <a href=\"https:\/\/www.linkedin.com\/in\/steven-naudet-aa540158\/\">Steven Naudet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Earlier this week someone tried to show me how to capture page split events using Extended Events (XE) but unfortunately, the demo failed. This is a good opportunity for me to refresh my knowledge about page split and set up a simple demo about this. Hopefully, this one will be working. It\u2019s not necessarily a [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":13587,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,99],"tags":[2550],"type_dbi":[],"class_list":["post-13586","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-sql-server","tag-sql-server-2"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server: Collect Page Split events using Extended Event session - dbi Blog<\/title>\n<meta name=\"description\" content=\"In this blog post we see how to easily trigger a page split events of type UPDATE and capture them using an Extended Event Session. We use the new DMV\u00a0sys.dm_db_page_info when reading the XE session data.\" \/>\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-collect-page-split-events-using-extended-event-session\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: Collect Page Split events using Extended Event session\" \/>\n<meta property=\"og:description\" content=\"In this blog post we see how to easily trigger a page split events of type UPDATE and capture them using an Extended Event Session. We use the new DMV\u00a0sys.dm_db_page_info when reading the XE session data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-04T19:24:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-01T09:39:39+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png\" \/>\n\t<meta property=\"og:image:width\" content=\"911\" \/>\n\t<meta property=\"og:image:height\" content=\"56\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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-collect-page-split-events-using-extended-event-session\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server: Collect Page Split events using Extended Event session\",\"datePublished\":\"2020-03-04T19:24:28+00:00\",\"dateModified\":\"2025-10-01T09:39:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/\"},\"wordCount\":568,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png\",\"keywords\":[\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/\",\"name\":\"SQL Server: Collect Page Split events using Extended Event session - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png\",\"datePublished\":\"2020-03-04T19:24:28+00:00\",\"dateModified\":\"2025-10-01T09:39:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"description\":\"In this blog post we see how to easily trigger a page split events of type UPDATE and capture them using an Extended Event Session. We use the new DMV\u00a0sys.dm_db_page_info when reading the XE session data.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png\",\"width\":911,\"height\":56},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: Collect Page Split events using Extended Event session\"}]},{\"@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\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server: Collect Page Split events using Extended Event session - dbi Blog","description":"In this blog post we see how to easily trigger a page split events of type UPDATE and capture them using an Extended Event Session. We use the new DMV\u00a0sys.dm_db_page_info when reading the XE session data.","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-collect-page-split-events-using-extended-event-session\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: Collect Page Split events using Extended Event session","og_description":"In this blog post we see how to easily trigger a page split events of type UPDATE and capture them using an Extended Event Session. We use the new DMV\u00a0sys.dm_db_page_info when reading the XE session data.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/","og_site_name":"dbi Blog","article_published_time":"2020-03-04T19:24:28+00:00","article_modified_time":"2025-10-01T09:39:39+00:00","og_image":[{"width":911,"height":56,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png","type":"image\/png"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server: Collect Page Split events using Extended Event session","datePublished":"2020-03-04T19:24:28+00:00","dateModified":"2025-10-01T09:39:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/"},"wordCount":568,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png","keywords":["SQL Server"],"articleSection":["Database Administration &amp; Monitoring","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/","name":"SQL Server: Collect Page Split events using Extended Event session - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png","datePublished":"2020-03-04T19:24:28+00:00","dateModified":"2025-10-01T09:39:39+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"description":"In this blog post we see how to easily trigger a page split events of type UPDATE and capture them using an Extended Event Session. We use the new DMV\u00a0sys.dm_db_page_info when reading the XE session data.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SNA_XE_Page_split_1-e1583316038611.png","width":911,"height":56},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-collect-page-split-events-using-extended-event-session\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: Collect Page Split events using Extended Event session"}]},{"@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\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13586","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\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=13586"}],"version-history":[{"count":3,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13586\/revisions"}],"predecessor-version":[{"id":40582,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13586\/revisions\/40582"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/13587"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13586"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}