{"id":537,"date":"2010-12-27T22:38:00","date_gmt":"2010-12-27T22:38:00","guid":{"rendered":"\/blogs\/jonathan\/post\/An-XEvent-a-Day-(27-of-31)-The-Future-Tracking-Page-Splits-in-SQL-Server-Denali-CTP1.aspx"},"modified":"2017-04-13T13:05:42","modified_gmt":"2017-04-13T17:05:42","slug":"an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/","title":{"rendered":"An XEvent a Day (27 of 31) – The Future – Tracking Page Splits in SQL Server Denali CTP1"},"content":{"rendered":"

\nNearly two years ago Kalen Delaney blogged about Splitting a page into multiple pages<\/a>, showing how page splits occur inside of SQL Server.  Following her blog post, Michael Zilberstein wrote a post, Monitoring Page Splits with Extended Events<\/a>, that showed how to see the sqlserver.page_split Events using Extended Events.  Eladio Rincón also blogged about Using XEvents (Extended Events) in SQL Server 2008 to detect which queries are causing Page Splits<\/a>, but not in relation to Kalen’s blog post.  Both of these blog posts demonstrate how to get the sqlserver.page_split Events, but as discussed in the comments section of Michael Zilberstein’s blog post, the Event fires for all page splits and Adam Machanic and I talked after Eladio’s blog post and opened a connect item to have the sqlserver.page_split Event extended in the product so that you know what kind of split is actually occurring.\n<\/p>\n

\nhttps:\/\/connect.microsoft.com\/SQLServer\/feedback\/details\/388482\/sql-server-extended-events-page-split-event-additions<\/a>\n<\/p>\n

\nThe CTP1 release of Denali has significant changes to the sqlserver.page_split Event, that makes it easier to find the splitting object as well the type of split that is occurring.  Before we look at that, I am going to show the code required to get the object and index information from SQL Server 2008, which is based on Adam’s comments to use sys.dm_os_buffer_descriptors.  For the examples in this blog post I am going use Kalen’s multipage split example from her blog post referenced above.\n<\/p>\n

\n
\r\n\t-- Create the table \r\n\t<\/font>USE <\/font>tempdb<\/font>;\r\n\t<\/font>GO\r\n\t<\/font>SET NOCOUNT ON\r\n\t<\/font>GO\r\n\t<\/font>IF <\/font>EXISTS (<\/font>SELECT <\/font>* <\/font>FROM <\/font>sys.tables\r\n\t            <\/font>WHERE <\/font>name <\/font>= <\/font>'split_page'<\/font>)\r\n\t    <\/font>DROP TABLE <\/font>split_page<\/font>;\r\n\t<\/font>GO\r\n\t<\/font>CREATE TABLE <\/font>split_page \r\n\t<\/font>(<\/font>id <\/font>INT <\/font>IDENTITY<\/font>(<\/font>0<\/font>,<\/font>2<\/font>) <\/font>PRIMARY KEY<\/font>,\r\n\t<\/font>id2 bigint <\/font>DEFAULT <\/font>0<\/font>,\r\n\t<\/font>data1 <\/font>VARCHAR<\/font>(<\/font>33<\/font>) NULL, \r\n\t<\/font>data2 <\/font>VARCHAR<\/font>(<\/font>8000<\/font>) NULL);\r\n\t<\/font>GO\r\n\t<\/font>-- fill page until no more rows fit\r\n\t<\/font>INSERT INTO <\/font>split_page <\/font>DEFAULT VALUES<\/font>;\r\n\t<\/font>GO 385\r\n\t<\/font>-- verify that there is only one data page \r\n\t<\/font>DBCC <\/font>IND<\/font>(<\/font>tempdb<\/font>, <\/font>split_page<\/font>, -<\/font>1<\/font>);\r\n\t<\/font>-- Create MonitorPageSplits Extended Event Session \r\n\t<\/font>IF <\/font>(<\/font>SELECT <\/font>1 <\/font>FROM <\/font>sys.server_event_sessions <\/font>WHERE <\/font>name <\/font>= <\/font>'MonitorPageSplits'<\/font>) <\/font>IS <\/font>NOT NULL \r\n\t   <\/font>DROP <\/font>EVENT SESSION MonitorPageSplits <\/font>ON <\/font>SERVER \r\n\tGO \r\n\t<\/font>CREATE <\/font>EVENT SESSION MonitorPageSplits <\/font>ON <\/font>SERVER \r\n\t<\/font>ADD <\/font>EVENT sqlserver.page_split \r\n\t<\/font>( \r\n\t    <\/font>ACTION <\/font>(<\/font>sqlserver.database_id<\/font>, <\/font>sqlserver.sql_text<\/font>)   \r\n\t    <\/font>WHERE <\/font>sqlserver.database_id <\/font>= <\/font>2 \r\n\t<\/font>) \r\n\t<\/font>ADD <\/font>TARGET package0.ring_buffer \r\n\t<\/font>WITH<\/font>(<\/font>MAX_DISPATCH_LATENCY <\/font>= <\/font>1 SECONDS<\/font>)\r\n\t<\/font>GO \r\n\t<\/font>-- Start the MonitorPageSplits Event Session \r\n\t<\/font>ALTER <\/font>EVENT SESSION MonitorPageSplits <\/font>ON <\/font>SERVER STATE <\/font>= <\/font>start<\/font>; \r\n\t<\/font>GO \r\n\t<\/font>-- Now insert one more row, this time filling the VARCHARs to the maximum length. \r\n\t<\/font>SET IDENTITY_INSERT <\/font>split_page  <\/font>ON<\/font>;\r\n\t<\/font>GO\r\n\t<\/font>INSERT INTO <\/font>split_page <\/font>(<\/font>id<\/font>, <\/font>id2<\/font>, <\/font>data1<\/font>, <\/font>data2<\/font>)\r\n\t      <\/font>SELECT <\/font>111<\/font>, <\/font>0<\/font>, <\/font>REPLICATE<\/font>(<\/font>'a'<\/font>, <\/font>33<\/font>), <\/font>REPLICATE<\/font>(<\/font>'b'<\/font>, <\/font>8000<\/font>);\r\n\t<\/font>GO\r\n\t<\/font>SET IDENTITY_INSERT <\/font>split_page  <\/font>OFF<\/font>;\r\n\t<\/font>GO \r\n\t<\/font>ALTER <\/font>EVENT SESSION MonitorPageSplits <\/font>ON <\/font>SERVER \r\n\t<\/font>DROP <\/font>EVENT sqlserver.page_split<\/font>; \r\n\t<\/font>GO \r\n\t<\/font>-- Wait to allow dispatch to complete\r\n\t<\/font>WAITFOR <\/font>DELAY <\/font>'00:00:01.000' \r\n\t<\/font>GO\r\n\t<\/font>SELECT <\/font>oTab.<\/font>*\r\n\t  , <\/font>p.<\/font>OBJECT_ID\r\n\t  <\/font>, <\/font>p.index_id\r\n\t  <\/font>, <\/font>OBJECT_NAME<\/font>(<\/font>p.<\/font>OBJECT_ID<\/font>)\r\n\t  , <\/font>i.name\r\n\t<\/font>FROM\r\n\t<\/font>(\r\n\t<\/font>SELECT \r\n\t    <\/font>XEvent            <\/font>= <\/font>XEvent.query<\/font>(<\/font>'.'<\/font>) \r\n\t  , <\/font>time              <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(@timestamp)[1]'<\/font>,<\/font>'datetime'<\/font>) \r\n\t  , <\/font>FILE_ID           <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(data[@name=''file_id'']\/value)[1]'<\/font>,<\/font>'int'<\/font>) \r\n\t  , <\/font>page_id           <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(data[@name=''page_id'']\/value)[1]'<\/font>,<\/font>'int'<\/font>) \r\n\t  , <\/font>database_id       <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(action[@name=''database_id'']\/value)[1]'<\/font>,<\/font>'int'<\/font>) \r\n\t  , <\/font>sql_text          <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(action[@name=''sql_text'']\/value)[1]'<\/font>,<\/font>'varchar(max)'<\/font>) \r\n\t<\/font>FROM \r\n\t<\/font>( \r\n\t   <\/font>SELECT <\/font>CAST<\/font>(<\/font>target_data <\/font>AS XML<\/font>) <\/font>AS <\/font>target_data \r\n\t   <\/font>FROM <\/font>sys.dm_xe_session_targets xst \r\n\t   <\/font>JOIN <\/font>sys.dm_xe_sessions xs <\/font>ON <\/font>xs.address <\/font>= <\/font>xst.event_session_address \r\n\t   <\/font>WHERE <\/font>xs.name <\/font>= <\/font>'MonitorPageSplits' \r\n\t<\/font>) <\/font>AS <\/font>tab <\/font>(<\/font>target_data<\/font>) \r\n\tCROSS <\/font>APPLY target_data.nodes<\/font>(<\/font>'\/RingBufferTarget\/event'<\/font>) <\/font>AS <\/font>EventNodes<\/font>(<\/font>XEvent<\/font>) \r\n\t) <\/font>AS <\/font>oTab\r\n\t<\/font>LEFT <\/font>JOIN <\/font>sys.dm_os_buffer_descriptors <\/font>AS <\/font>obd\r\n\t   <\/font>ON <\/font>obd.database_id <\/font>= <\/font>oTab.database_id\r\n\t       <\/font>AND <\/font>obd.<\/font>FILE_ID <\/font>= <\/font>oTab.<\/font>FILE_ID\r\n\t       <\/font>AND <\/font>obd.page_id <\/font>= <\/font>oTab.page_id\r\n\t<\/font>LEFT <\/font>JOIN <\/font>sys.allocation_units au\r\n\t   <\/font>ON <\/font>au.allocation_unit_id <\/font>= <\/font>obd.allocation_unit_id\r\n\t<\/font>LEFT <\/font>JOIN <\/font>sys.partitions p \r\n\t   <\/font>ON <\/font>p.partition_id <\/font>= <\/font>au.container_id  \r\n\t<\/font>LEFT <\/font>JOIN <\/font>sys.indexes i\r\n\t   <\/font>ON <\/font>p.<\/font>OBJECT_ID <\/font>= <\/font>i.<\/font>OBJECT_ID\r\n\t       <\/font>AND <\/font>p.index_id <\/font>= <\/font>i.index_id\r\n\t<\/font>-- verify that there is only one data page \r\n\t<\/font>DBCC <\/font>IND<\/font>(<\/font>tempdb<\/font>, <\/font>split_page<\/font>, -<\/font>1<\/font>);\r\n\t<\/font>\r\n\t<\/pre>\n<\/blockquote>\n
\nThe above code creates a table in tempdb, loads one page of data in it exactly as in Kalen’s blog post, and then creates an Event Session for the sqlserver.page_split Event in tempdb, that also collects the sqlserver.database_id and sqlserver.sql_text actions when the Event fires.  After triggering the page split, it drops the Event from the Event Session and then uses WAITFOR DELAY to allow the events to be buffered to the package0.ring_buffer Target.  Then it shreds the XML and joins to the DMV’s to get the object and index names.  The output of running the above script in SQL Server 2008 should be similar to the following, showing 10 split events and 10 additional pages in the database table.\n<\/p>\n
\n \"image\"<\/a> . \n<\/p>\n
\nNote that the only two columns returned by the sqlserver.page_split Event are the file_id and page_id.  In SQL Server Denali CTP1, the sqlserver.page_split event now has a much larger Event payload associated with it.  It now returns the file_id, page_id, database_id (as a part of the event, not requiring an action), rowset_id, splitOperation, new_page_file_id, and the new_page_page_id associated with the page_split Event.   This makes the Event much more useful and allows it to be used without having to query the buffer descriptors to find the object association.  The following demo is identical to the demo for SQL Server 2008 listed above with the exception of that the XQuery is slightly different (a requirement to pull the new information from the XML).\n<\/p>\n
\n
\r\n\t-- Create the table \r\n\t<\/font>USE <\/font>tempdb<\/font>;\r\n\t<\/font>GO\r\n\t<\/font>SET NOCOUNT ON\r\n\t<\/font>GO\r\n\t<\/font>IF <\/font>EXISTS (<\/font>SELECT <\/font>* <\/font>FROM <\/font>sys.tables\r\n\t            <\/font>WHERE <\/font>name <\/font>= <\/font>'split_page'<\/font>)\r\n\t    <\/font>DROP TABLE <\/font>split_page<\/font>;\r\n\t<\/font>GO\r\n\t<\/font>CREATE TABLE <\/font>split_page \r\n\t<\/font>(<\/font>id <\/font>INT <\/font>IDENTITY<\/font>(<\/font>0<\/font>,<\/font>2<\/font>) <\/font>PRIMARY KEY<\/font>,\r\n\t<\/font>id2 bigint <\/font>DEFAULT <\/font>0<\/font>,\r\n\t<\/font>data1 <\/font>VARCHAR<\/font>(<\/font>33<\/font>) NULL, \r\n\t<\/font>data2 <\/font>VARCHAR<\/font>(<\/font>8000<\/font>) NULL);\r\n\t<\/font>GO\r\n\t<\/font>-- fill page until no more rows fit\r\n\t<\/font>INSERT INTO <\/font>split_page <\/font>DEFAULT VALUES<\/font>;\r\n\t<\/font>GO 385\r\n\t<\/font>-- verify that there is only one data page \r\n\t<\/font>DBCC <\/font>IND<\/font>(<\/font>tempdb<\/font>, <\/font>split_page<\/font>, -<\/font>1<\/font>);\r\n\t<\/font>-- Create MonitorPageSplits Extended Event Session \r\n\t<\/font>IF <\/font>(<\/font>SELECT <\/font>1 <\/font>FROM <\/font>sys.server_event_sessions <\/font>WHERE <\/font>name <\/font>= <\/font>'MonitorPageSplits'<\/font>) <\/font>IS <\/font>NOT NULL \r\n\t   <\/font>DROP <\/font>EVENT SESSION MonitorPageSplits <\/font>ON <\/font>SERVER \r\n\tGO \r\n\t<\/font>CREATE <\/font>EVENT SESSION MonitorPageSplits <\/font>ON <\/font>SERVER \r\n\t<\/font>ADD <\/font>EVENT sqlserver.page_split \r\n\t<\/font>( \r\n\t    <\/font>ACTION <\/font>(<\/font>sqlserver.database_id<\/font>, <\/font>sqlserver.sql_text<\/font>)   \r\n\t    <\/font>WHERE <\/font>sqlserver.database_id <\/font>= <\/font>2 \r\n\t<\/font>) \r\n\t<\/font>ADD <\/font>TARGET package0.ring_buffer \r\n\t<\/font>WITH <\/font>(<\/font>MAX_DISPATCH_LATENCY <\/font>= <\/font>1 SECONDS<\/font>)\r\n\t<\/font>GO \r\n\t<\/font>-- Start the MonitorPageSplits Event Session \r\n\t<\/font>ALTER <\/font>EVENT SESSION MonitorPageSplits <\/font>ON <\/font>SERVER STATE <\/font>= <\/font>start<\/font>; \r\n\t<\/font>GO \r\n\t<\/font>-- Now insert one more row, this time filling the VARCHARs to the maximum length. \r\n\t<\/font>SET IDENTITY_INSERT <\/font>split_page  <\/font>ON<\/font>;\r\n\t<\/font>GO\r\n\t<\/font>INSERT INTO <\/font>split_page <\/font>(<\/font>id<\/font>, <\/font>id2<\/font>, <\/font>data1<\/font>, <\/font>data2<\/font>)\r\n\t      <\/font>SELECT <\/font>111<\/font>, <\/font>0<\/font>, <\/font>REPLICATE<\/font>(<\/font>'a'<\/font>, <\/font>33<\/font>), <\/font>REPLICATE<\/font>(<\/font>'b'<\/font>, <\/font>8000<\/font>);\r\n\t<\/font>GO\r\n\t<\/font>SET IDENTITY_INSERT <\/font>split_page  <\/font>OFF<\/font>;\r\n\t<\/font>GO \r\n\t<\/font>ALTER <\/font>EVENT SESSION MonitorPageSplits <\/font>ON <\/font>SERVER \r\n\t<\/font>DROP <\/font>EVENT sqlserver.page_split<\/font>; \r\n\t<\/font>\r\n\t<\/font>GO\r\n\t<\/font>SELECT \r\n\t    <\/font>event_time         <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(@timestamp)[1]'<\/font>,<\/font>'datetime'<\/font>) \r\n\t  , <\/font>orig_file_id      <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(data[@name=''file_id'']\/value)[1]'<\/font>,<\/font>'int'<\/font>) \r\n\t  , <\/font>orig_page_id      <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(data[@name=''page_id'']\/value)[1]'<\/font>,<\/font>'int'<\/font>) \r\n\t  , <\/font>database_id           <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(data[@name=''database_id'']\/value)[1]'<\/font>,<\/font>'int'<\/font>) \r\n\t  , <\/font>OBJECT_ID         <\/font>= <\/font>p.<\/font>OBJECT_ID\r\n\t  <\/font>, <\/font>index_id          <\/font>= <\/font>p.index_id\r\n\t  <\/font>, <\/font>OBJECT_NAME           <\/font>= <\/font>OBJECT_NAME<\/font>(<\/font>p.<\/font>OBJECT_ID<\/font>)\r\n\t  , <\/font>index_name            <\/font>= <\/font>i.name\r\n\t  <\/font>, <\/font>rowset_id         <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(data[@name=''rowset_id'']\/value)[1]'<\/font>,<\/font>'bigint'<\/font>) \r\n\t  , <\/font>splitOperation        <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(data[@name=''splitOperation'']\/text)[1]'<\/font>,<\/font>'varchar(255)'<\/font>) \r\n\t  , <\/font>new_page_file_id  <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(data[@name=''new_page_file_id'']\/value)[1]'<\/font>,<\/font>'int'<\/font>) \r\n\t  , <\/font>new_page_page_id  <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(data[@name=''new_page_page_id'']\/value)[1]'<\/font>,<\/font>'int'<\/font>) \r\n\t  , <\/font>sql_text          <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(action[@name=''sql_text'']\/value)[1]'<\/font>,<\/font>'varchar(max)'<\/font>) \r\n\t<\/font>FROM \r\n\t<\/font>( \r\n\t   <\/font>SELECT <\/font>CAST<\/font>(<\/font>target_data <\/font>AS XML<\/font>) <\/font>AS <\/font>target_data \r\n\t   <\/font>FROM <\/font>sys.dm_xe_session_targets xst \r\n\t   <\/font>JOIN <\/font>sys.dm_xe_sessions xs <\/font>ON <\/font>xs.address <\/font>= <\/font>xst.event_session_address \r\n\t   <\/font>WHERE <\/font>xs.name <\/font>= <\/font>'MonitorPageSplits' \r\n\t<\/font>) <\/font>AS <\/font>tab <\/font>(<\/font>target_data<\/font>) \r\n\tCROSS <\/font>APPLY target_data.nodes<\/font>(<\/font>'\/RingBufferTarget\/event'<\/font>) <\/font>AS <\/font>EventNodes<\/font>(<\/font>XEvent<\/font>) \r\n\t<\/font>LEFT <\/font>JOIN <\/font>sys.allocation_units au\r\n\t   <\/font>ON <\/font>au.container_id <\/font>= <\/font>XEvent.value<\/font>(<\/font>'(data[@name=''rowset_id'']\/value)[1]'<\/font>,<\/font>'bigint'<\/font>) \r\n\t<\/font>LEFT <\/font>JOIN <\/font>sys.partitions p \r\n\t   <\/font>ON <\/font>p.partition_id <\/font>= <\/font>au.container_id  \r\n\t<\/font>LEFT <\/font>JOIN <\/font>sys.indexes i\r\n\t   <\/font>ON <\/font>p.<\/font>OBJECT_ID <\/font>= <\/font>i.<\/font>OBJECT_ID\r\n\t       <\/font>AND <\/font>p.index_id <\/font>= <\/font>i.index_id\r\n\t<\/font>-- View the Page allocations \r\n\t<\/font>DBCC <\/font>IND<\/font>(<\/font>tempdb<\/font>, <\/font>split_page<\/font>, -<\/font>1<\/font>);<\/font>\r\n\t<\/pre>\n<\/blockquote>\n
\nIf you run the above demo the output should be similar to the below (if you click on the picture, it will open up larger).  One thing that should become immediately obvious is that the same demo in Denali is doing 1\/3rd of the page splits that occur in SQL Server 2008. \n<\/p>\n
\n\"image\"<\/a>\n<\/p>\n
\nThe old_page_id and new_page_id tell where the page originated and moved to, and the splitOperation tells the type of split.  In this case only two of the type of splits are occurring; SPLIT_FOR_ROOT_NODE which occurs when the first page allocated is split into multiple pages, and SPLIT_FOR_INSERT which occurs as the inserts continue and the pages are split to accommodate the data.  There are a number of additional split operations that exist in SQL Server Denali CTP1 including, SPLIT_FOR_DELETE, SPLIT_FOR_GHOST, SPLIT_FOR_INTERNAL_NODE, and SPLIT_FOR_UPDATE.  I’ve tried to figure out how to correlate the output from DBCC IND with the data held in the Event Session for page splits to correlate the old_page_id and new_page_id to identify problematic splits, but haven’t finalized validation of my tests yet (hopefully I can finish this work and I’ll write an update to this blog post showing how to do this at some point in the near future).  One item that I have noted in my testing is that mid-page splits generally generate multiple sqlserver.page_split Events in the same operation, similar to the demonstrations used in this example, where as end-page splits for identity and sequential GUID inserts do not.  I am not certain that this is a valid conclusion to come to at this point and have further testing to do to investigate page splits more.<\/p>\n","protected":false},"excerpt":{"rendered":"
Nearly two years ago Kalen Delaney blogged about Splitting a page into multiple pages, showing how page splits occur inside of SQL Server.  Following her blog post, Michael Zilberstein wrote a post, Monitoring Page Splits with Extended Events, that showed how to see the sqlserver.page_split Events using Extended Events.  Eladio Rincón also blogged about Using […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,38,40,45],"tags":[],"class_list":["post-537","post","type-post","status-publish","format-standard","hentry","category-extended-events","category-sql-server-2008","category-sql-server-denali","category-xevent-a-day-series"],"yoast_head":"\nAn XEvent a Day (27 of 31) - The Future - Tracking Page Splits in SQL Server Denali CTP1 - Jonathan Kehayias<\/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.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"An XEvent a Day (27 of 31) - The Future - Tracking Page Splits in SQL Server Denali CTP1 - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"Nearly two years ago Kalen Delaney blogged about Splitting a page into multiple pages, showing how page splits occur inside of SQL Server.  Following her blog post, Michael Zilberstein wrote a post, Monitoring Page Splits with Extended Events, that showed how to see the sqlserver.page_split Events using Extended Events.  Eladio Rincón also blogged about Using […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-27T22:38:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T17:05:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/trackingpagesplitsinsqlserverdenalictp1\/007ef04c\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Jonathan Kehayias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Kehayias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"An XEvent a Day (27 of 31) – The Future – Tracking Page Splits in SQL Server Denali CTP1\",\"datePublished\":\"2010-12-27T22:38:00+00:00\",\"dateModified\":\"2017-04-13T17:05:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/\"},\"wordCount\":865,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/trackingpagesplitsinsqlserverdenalictp1\\\/007ef04c\\\/image_thumb.png\",\"articleSection\":[\"Extended Events\",\"SQL Server 2008\",\"SQL Server Denali\",\"XEvent a Day Series\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/\",\"name\":\"An XEvent a Day (27 of 31) - The Future - Tracking Page Splits in SQL Server Denali CTP1 - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/trackingpagesplitsinsqlserverdenalictp1\\\/007ef04c\\\/image_thumb.png\",\"datePublished\":\"2010-12-27T22:38:00+00:00\",\"dateModified\":\"2017-04-13T17:05:42+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/trackingpagesplitsinsqlserverdenalictp1\\\/007ef04c\\\/image_thumb.png\",\"contentUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/trackingpagesplitsinsqlserverdenalictp1\\\/007ef04c\\\/image_thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extended Events\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/extended-events\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"An XEvent a Day (27 of 31) – The Future – Tracking Page Splits in SQL Server Denali CTP1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\",\"name\":\"Jonathan Kehayias - The Rambling DBA\",\"description\":\"The Rambling DBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\",\"name\":\"Jonathan Kehayias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"caption\":\"Jonathan Kehayias\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/jonathan\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"An XEvent a Day (27 of 31) - The Future - Tracking Page Splits in SQL Server Denali CTP1 - Jonathan Kehayias","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.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/","og_locale":"en_US","og_type":"article","og_title":"An XEvent a Day (27 of 31) - The Future - Tracking Page Splits in SQL Server Denali CTP1 - Jonathan Kehayias","og_description":"Nearly two years ago Kalen Delaney blogged about Splitting a page into multiple pages, showing how page splits occur inside of SQL Server.  Following her blog post, Michael Zilberstein wrote a post, Monitoring Page Splits with Extended Events, that showed how to see the sqlserver.page_split Events using Extended Events.  Eladio Rincón also blogged about Using […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/","og_site_name":"Jonathan Kehayias","article_published_time":"2010-12-27T22:38:00+00:00","article_modified_time":"2017-04-13T17:05:42+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/trackingpagesplitsinsqlserverdenalictp1\/007ef04c\/image_thumb.png","type":"","width":"","height":""}],"author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"An XEvent a Day (27 of 31) – The Future – Tracking Page Splits in SQL Server Denali CTP1","datePublished":"2010-12-27T22:38:00+00:00","dateModified":"2017-04-13T17:05:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/"},"wordCount":865,"commentCount":0,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/trackingpagesplitsinsqlserverdenalictp1\/007ef04c\/image_thumb.png","articleSection":["Extended Events","SQL Server 2008","SQL Server Denali","XEvent a Day Series"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/","name":"An XEvent a Day (27 of 31) - The Future - Tracking Page Splits in SQL Server Denali CTP1 - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/trackingpagesplitsinsqlserverdenalictp1\/007ef04c\/image_thumb.png","datePublished":"2010-12-27T22:38:00+00:00","dateModified":"2017-04-13T17:05:42+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/trackingpagesplitsinsqlserverdenalictp1\/007ef04c\/image_thumb.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/trackingpagesplitsinsqlserverdenalictp1\/007ef04c\/image_thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-27-of-31-the-future-tracking-page-splits-in-sql-server-denali-ctp1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Extended Events","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/extended-events\/"},{"@type":"ListItem","position":3,"name":"An XEvent a Day (27 of 31) – The Future – Tracking Page Splits in SQL Server Denali CTP1"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/","name":"Jonathan Kehayias - The Rambling DBA","description":"The Rambling DBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c","name":"Jonathan Kehayias","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","caption":"Jonathan Kehayias"},"sameAs":["http:\/\/3.209.169.194\/blogs\/jonathan"]}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/537","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/comments?post=537"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/537\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}