{"id":536,"date":"2010-12-28T20:25:00","date_gmt":"2010-12-28T20:25:00","guid":{"rendered":"\/blogs\/jonathan\/post\/An-XEvent-a-Day-(28-of-31)-e28093-Tracking-Page-Compression-Operations.aspx"},"modified":"2017-04-13T12:16:35","modified_gmt":"2017-04-13T16:16:35","slug":"an-xevent-a-day-28-of-31-tracking-page-compression-operations","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/","title":{"rendered":"An XEvent a Day (28 of 31) – Tracking Page Compression Operations"},"content":{"rendered":"

The Database Compression feature in SQL Server 2008 Enterprise Edition can provide some significant reductions in storage requirements for SQL Server databases, and in the right implementations and scenarios performance improvements as well.  There isn\u2019t really a whole lot of information about the operations of database compression that is documented as being available in the DMV\u2019s or SQL Trace.  Paul Randal pointed out on Twitter today that sys.dm_db_index_operational_stats() provides the page_compression_attempt_count and page_compression_success_count available.  Beyond that the only other documented information for monitoring Data Compression are the Page Compression Attempts\/sec and Pages Compressed\/sec Performance Counters of the SQL Server:Access Methods object in Perfmon (http:\/\/msdn.microsoft.com\/en-us\/library\/cc280449.aspx<\/a>).  <\/p>\n

There is one thing in common about the documented methods of monitoring Data Compression, and that is they all only deal with Page compression, and not Row compression, and in Extended Events we find the same commonality as there are no Row compression Events in Extended Events.  There are two Page compression Events in Extended Events; sqlserver.page_compression_attempt_failed and sqlserver.page_compression_tracing.  These two Events can be used to track Page compression operations at multiple levels, including database, object, index, and even down to the individual page. The sqlserver.page_compression_tracing Event provides Start and End tracing of Page compression operations inside of the Database Engine and returns the database_id, index_id, rowset_id, page_id, and duration of the compression operation.  The sqlserver.page_compression_attempt_failed is really poorly named, and doesn\u2019t provide information about failures in the sense that something broke, but provides information for why a page compression attempt did not actually change the compression of the data in the page.  It also returns the database_id, index_id, rowset_id, and page_id for the compression attempt, and it also includes a failure_reason column which correlates to the page_compression_failure_reason Map Value.<\/p>\n

\n
-- Get the payload information for the Events \r\n<\/span>SELECT \r\n    <\/span>object_name<\/span>, \r\n    <\/span>column_id, \r\n    <\/span>name, \r\n    <\/span>type_name\r\n<\/span>FROM <\/span>sys<\/span>.<\/span>dm_xe_object_columns\r\n<\/span>WHERE <\/span>object_name <\/span>IN (<\/span>'page_compression_tracing'<\/span>, \r\n                      <\/span>'page_compression_attempt_failed'<\/span>)\r\n  AND <\/span>column_type = <\/span>'data'<\/span><\/pre>\n<\/blockquote>\n
\n
\"image\"<\/a> <\/p>\n<\/blockquote>\n
To demonstrate how these Events function, I am going to use the LineItem table from the TPC-H Benchmark that was created by Quest Benchmark Factory using Level 2 for the table sizing, which makes the table just at 1.8GB in size.  All of the indexes on the table will be rebuilt using PAGE compression, and then 10,000 rows will be added to the table.  To setup the environment, first load the TPC-H LineItem table with the appropriate seed of data, this can be done with the free trial version of Benchmark Factory.  Then rebuild all of the indexes on the LineItem table using PAGE compression, and review the PAGE compression statistics from sys.dm_db_index_operational_stats for the database and object.<\/p>\n
\n
USE <\/span>[TPCH]\r\nGO\r\n<\/span>-- Rebuild the indexes with Page compression \r\n<\/span>ALTER INDEX <\/span>ALL <\/span>ON <\/span>dbo.<\/span>H_Lineitem REBUILD WITH <\/span>(<\/span>DATA_COMPRESSION = <\/span>PAGE)\r\n<\/span>GO\r\n<\/span>-- Look at the compression information in sys.dm_db_index_operational_stats\r\n<\/span>SELECT \r\n    <\/span>database_id, \r\n    <\/span>object_id<\/span>, \r\n    <\/span>index_id, \r\n    <\/span>page_compression_attempt_count, \r\n    <\/span>page_compression_success_count,\r\n    (<\/span>page_compression_attempt_count - <\/span>page_compression_success_count) <\/span>as <\/span>page_compression_failure_count\r\nFROM <\/span>sys<\/span>.<\/span>dm_db_index_operational_stats<\/span>(<\/span>db_id<\/span>(<\/span>'TPCH'<\/span>), <\/span>object_id<\/span>(<\/span>'H_Lineitem'<\/span>), null, null)\r\n<\/span>GO<\/span><\/pre>\n<\/blockquote>\n
\n
\"image\"<\/a> <\/p>\n<\/blockquote>\n
Once the table and its indexes have been rebuilt using PAGE compression, we can then create our Event Session, start it, and add 10,000 rows to the LineItem table.  After we add the rows, we can then check the page compression statistics in sys.dm_db_index_operational_stats, and drop our Event Session from the server. <\/p>\n
\n
-- Create an Event Session to Track the Failed attempts\r\n<\/span>CREATE EVENT SESSION <\/span>PageCompressionTracing\r\nON SERVER\r\nADD EVENT <\/span>sqlserver.<\/span>page_compression_attempt_failed,\r\n<\/span>ADD EVENT <\/span>sqlserver.<\/span>page_compression_tracing\r\nADD TARGET <\/span>package0.<\/span>asynchronous_file_target(\r\n     <\/span>SET filename<\/span>=<\/span>'C:\\SQLBlog\\PageCompressionTracing.xel'<\/span>,\r\n         <\/span>metadatafile=<\/span>'C:\\SQLBlog\\PageCompressionTracing.xem'<\/span>)\r\n<\/span>WITH <\/span>(<\/span>MAX_MEMORY = <\/span>8MB, <\/span>EVENT_RETENTION_MODE = <\/span>ALLOW_SINGLE_EVENT_LOSS, <\/span>MAX_DISPATCH_LATENCY=<\/span>5SECONDS)\r\n<\/span>GO\r\n<\/span>-- Start the Event Session\r\n<\/span>ALTER EVENT SESSION <\/span>PageCompressionTracing\r\nON SERVER\r\nSTATE<\/span>=<\/span>START\r\nGO\r\n<\/span>-- Insert 10000 rows into the H_Lineitem table\r\n<\/span>INSERT INTO <\/span>H_Lineitem\r\n    (<\/span>l_orderkey, <\/span>l_partkey, <\/span>l_suppkey, <\/span>l_linenumber, <\/span>l_quantity, \r\n     <\/span>l_extendedprice, <\/span>l_discount, <\/span>l_tax, <\/span>l_returnflag, <\/span>l_linestatus, \r\n     <\/span>l_shipdate, <\/span>l_commitdate, <\/span>l_receiptdate, <\/span>l_shipinstruct, <\/span>l_shipmode, \r\n     <\/span>l_comment)\r\n<\/span>SELECT TOP <\/span>10000 \r\n     l_orderkey, <\/span>l_partkey, <\/span>l_suppkey, <\/span>l_linenumber, <\/span>l_quantity, \r\n     <\/span>l_extendedprice, <\/span>l_discount, <\/span>l_tax, <\/span>l_returnflag, <\/span>l_linestatus, \r\n     <\/span>l_shipdate, <\/span>l_commitdate, <\/span>l_receiptdate, <\/span>l_shipinstruct, <\/span>l_shipmode, \r\n     <\/span>l_comment\r\nFROM <\/span>H_Lineitem\r\nGO\r\n<\/span>-- Look at the compression information in sys.dm_db_index_operational_stats\r\n<\/span>SELECT \r\n    <\/span>database_id, \r\n    <\/span>object_id<\/span>, \r\n    <\/span>index_id, \r\n    <\/span>page_compression_attempt_count, \r\n    <\/span>page_compression_success_count,\r\n    (<\/span>page_compression_attempt_count - <\/span>page_compression_success_count) <\/span>as <\/span>page_compression_failure_count\r\nFROM <\/span>sys<\/span>.<\/span>dm_db_index_operational_stats<\/span>(<\/span>db_id<\/span>(<\/span>'TPCH'<\/span>), <\/span>object_id<\/span>(<\/span>'H_Lineitem'<\/span>), null, null)\r\n<\/span>GO\r\n<\/span>-- Drop the Event Session\r\n<\/span>DROP EVENT SESSION <\/span>PageCompressionTracing\r\nON SERVER\r\nGO<\/span><\/pre>\n<\/blockquote>\n
<\/blockquote>\n
\n
\"image\"<\/a> <\/p>\n<\/blockquote>\n
Now we can parse the Events that were captured by our Event Session and compare the information presented by sys.dm_db_index_operational_stats() with what was collected by Extended Events.<\/p>\n
\n
-- Create our result Analysis database\r\n<\/span>CREATE DATABASE <\/span>[PageCompTestResults]\r\nGO\r\nUSE <\/span>[PageCompTestResults]\r\nGO\r\n<\/span>-- Create intermediate temp table for raw event data\r\n<\/span>CREATE TABLE <\/span>RawEventData\r\n(<\/span>Rowid int identity primary key<\/span>, <\/span>event_data xml<\/span>)\r\n<\/span>GO\r\n<\/span>-- Read the file data into intermediate temp table\r\n<\/span>INSERT INTO <\/span>RawEventData (<\/span>event_data)\r\n<\/span>SELECT\r\n    <\/span>CAST<\/span>(<\/span>event_data AS XML<\/span>) <\/span>AS <\/span>event_data\r\nFROM <\/span>sys<\/span>.<\/span>fn_xe_file_target_read_file(<\/span>'C:\\SQLBlog\\PageCompressionTracing*.xel'<\/span>, \r\n                                     <\/span>'C:\\SQLBlog\\PageCompressionTracing*.xem'<\/span>, \r\n                                     null, null)\r\n<\/span>GO\r\n<\/span>-- Fetch the Event Data from the Event Session Target\r\n<\/span>SELECT \r\n    <\/span>RowID,\r\n    <\/span>event_data.<\/span>value(<\/span>'(event\/@name)[1]'<\/span>, <\/span>'varchar(50)'<\/span>) <\/span>AS <\/span>event_name,\r\n    <\/span>DATEADD<\/span>(<\/span>hh, \r\n            <\/span>DATEDIFF<\/span>(<\/span>hh, <\/span>GETUTCDATE<\/span>(), <\/span>CURRENT_TIMESTAMP<\/span>), \r\n            <\/span>event_data.<\/span>value(<\/span>'(event\/@timestamp)[1]'<\/span>, <\/span>'datetime2'<\/span>)) <\/span>AS <\/span>[timestamp],\r\n    <\/span>COALESCE<\/span>(<\/span>event_data.<\/span>value(<\/span>'(event\/data[@name="database_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>), \r\n             <\/span>event_data.<\/span>value(<\/span>'(event\/action[@name="database_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>)) <\/span>AS <\/span>database_id,\r\n    <\/span>event_data.<\/span>value(<\/span>'(event\/data[@name="file_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[file_id],\r\n    <\/span>event_data.<\/span>value(<\/span>'(event\/data[@name="page_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[page_id],\r\n    <\/span>event_data.<\/span>value(<\/span>'(event\/data[@name="rowset_id"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[rowset_id],\r\n    <\/span>event_data.<\/span>value(<\/span>'(event\/data[@name="failure_reason"]\/text)[1]'<\/span>, <\/span>'nvarchar(150)'<\/span>) <\/span>AS <\/span>[failure_reason],\r\n    <\/span>event_data.<\/span>value(<\/span>'(event\/action[@name="system_thread_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[system_thread_id],\r\n    <\/span>event_data.<\/span>value(<\/span>'(event\/action[@name="scheduler_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[scheduler_id],\r\n    <\/span>event_data.<\/span>value(<\/span>'(event\/action[@name="cpu_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[cpu_id]\r\nINTO <\/span>ParsedResults\r\nFROM <\/span>RawEventData\r\nGO<\/span><\/pre>\n<\/blockquote>\n
After parsing out the data, we can begin to really leverage the information we\u2019ve gathered.  If we join the ParsedResults table to sys.partitions for our TPCH database by rowset_id = hobt_id, we can get the object_id and index_id and aggregate the failure reasons up to the object and index level.<\/p>\n
\n
SELECT \r\n    <\/span>pr.<\/span>database_id, \r\n    <\/span>p.<\/span>object_id<\/span>, \r\n    <\/span>p.<\/span>index_id,\r\n    <\/span>failure_reason, \r\n    <\/span>COUNT<\/span>(*) <\/span>as <\/span>failure_count\r\nFROM <\/span>TPCH.<\/span>sys<\/span>.<\/span>partitions <\/span>p\r\nJOIN <\/span>ParsedResults pr\r\n    ON <\/span>pr.<\/span>rowset_id = <\/span>p.<\/span>hobt_id\r\nWHERE <\/span>event_name = <\/span>'page_compression_attempt_failed'\r\n<\/span>GROUP BY     <\/span>pr.<\/span>database_id, \r\n    <\/span>p.<\/span>object_id<\/span>, \r\n    <\/span>p.<\/span>index_id,\r\n    <\/span>failure_reason\r\nGO\r\n<\/span>-- Look at the compression information in sys.dm_db_index_operational_stats\r\n<\/span>SELECT \r\n    <\/span>database_id, \r\n    <\/span>object_id<\/span>, \r\n    <\/span>index_id, \r\n    <\/span>page_compression_attempt_count, \r\n    <\/span>page_compression_success_count,\r\n    (<\/span>page_compression_attempt_count - <\/span>page_compression_success_count) <\/span>as <\/span>page_compression_failure_count\r\nFROM <\/span>sys<\/span>.<\/span>dm_db_index_operational_stats<\/span>(<\/span>db_id<\/span>(<\/span>'TPCH'<\/span>), <\/span>object_id<\/span>(<\/span>'H_Lineitem'<\/span>), null, null)\r\n<\/span>GO<\/span><\/pre>\n<\/blockquote>\n
\n
\"image\"<\/a> <\/p>\n<\/blockquote>\n
With this we can se that the Extended Events sqlserver.page_compression_attempt_failed Event tracks failures and attempts that are not counted in sys.dm_db_index_operational_stats().  The PageModCountBelowThreshold failure isn\u2019t really a failed attempt at compression.  This reason shows that the page was evaluated for recalculation, and the modified counter for the page hadn\u2019t passed the internal threshold for recalculation so the actual compression operation wasn\u2019t performed.  If we look at the sqlserver.page_compression_tracing Event information, we can see how the numbers begin to come together to match what is output by sys.dm_db_index_operational_stats().<\/p>\n
\n
SELECT \r\n    <\/span>pr.<\/span>database_id, \r\n    <\/span>p.<\/span>object_id<\/span>, \r\n    <\/span>p.<\/span>index_id,\r\n    <\/span>COUNT<\/span>(*) <\/span>as <\/span>attempt_count\r\nFROM <\/span>TPCH.<\/span>sys<\/span>.<\/span>partitions <\/span>p\r\nJOIN <\/span>ParsedResults pr\r\n    ON <\/span>pr.<\/span>rowset_id = <\/span>p.<\/span>hobt_id\r\nWHERE <\/span>event_name = <\/span>'page_compression_tracing'\r\n  <\/span>AND <\/span>opcode = <\/span>'Begin'\r\n<\/span>GROUP BY     <\/span>pr.<\/span>database_id, \r\n    <\/span>p.<\/span>object_id<\/span>, \r\n    <\/span>p.<\/span>index_id\r\nGO\r\n<\/span>-- Look at the compression information in sys.dm_db_index_operational_stats\r\n<\/span>SELECT \r\n    <\/span>database_id, \r\n    <\/span>object_id<\/span>, \r\n    <\/span>index_id, \r\n    <\/span>page_compression_attempt_count, \r\n    <\/span>page_compression_success_count,\r\n    (<\/span>page_compression_attempt_count - <\/span>page_compression_success_count) <\/span>as <\/span>page_compression_failure_count\r\nFROM <\/span>sys<\/span>.<\/span>dm_db_index_operational_stats<\/span>(<\/span>db_id<\/span>(<\/span>'TPCH'<\/span>), <\/span>object_id<\/span>(<\/span>'H_Lineitem'<\/span>), null, null)\r\n<\/span>GO<\/span><\/pre>\n<\/blockquote>\n
\n
\"image\"<\/a> <\/p>\n<\/blockquote>\n
We have 193 attempts by this Event, and we have 72 PageModCountBelowThreshold failures, matching our actual attempts of 121 from the DMF.  We can then subtract out the other failures and get the 93 successful operations matching the DMF as well.<\/p>\n","protected":false},"excerpt":{"rendered":"
The Database Compression feature in SQL Server 2008 Enterprise Edition can provide some significant reductions in storage requirements for SQL Server databases, and in the right implementations and scenarios performance improvements as well.  There isn\u2019t really a whole lot of information about the operations of database compression that is documented as being available in the […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,23,38,40,45],"tags":[],"class_list":["post-536","post","type-post","status-publish","format-standard","hentry","category-database-administration","category-extended-events","category-sql-server-2008","category-sql-server-denali","category-xevent-a-day-series"],"yoast_head":"\nAn XEvent a Day (28 of 31) - Tracking Page Compression Operations - 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-28-of-31-tracking-page-compression-operations\/\" \/>\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 (28 of 31) - Tracking Page Compression Operations - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"The Database Compression feature in SQL Server 2008 Enterprise Edition can provide some significant reductions in storage requirements for SQL Server databases, and in the right implementations and scenarios performance improvements as well.  There isn\u2019t really a whole lot of information about the operations of database compression that is documented as being available in the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-28T20:25:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:16:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday28of31trackingfailedpagecomp\/0fac01f5\/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=\"8 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-28-of-31-tracking-page-compression-operations\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"An XEvent a Day (28 of 31) – Tracking Page Compression Operations\",\"datePublished\":\"2010-12-28T20:25:00+00:00\",\"dateModified\":\"2017-04-13T16:16:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\\\/\"},\"wordCount\":751,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/anxeventaday28of31trackingfailedpagecomp\\\/0fac01f5\\\/image_thumb.png\",\"articleSection\":[\"Database Administration\",\"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-28-of-31-tracking-page-compression-operations\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\\\/\",\"name\":\"An XEvent a Day (28 of 31) - Tracking Page Compression Operations - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/anxeventaday28of31trackingfailedpagecomp\\\/0fac01f5\\\/image_thumb.png\",\"datePublished\":\"2010-12-28T20:25:00+00:00\",\"dateModified\":\"2017-04-13T16:16:35+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-28-of-31-tracking-page-compression-operations\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/anxeventaday28of31trackingfailedpagecomp\\\/0fac01f5\\\/image_thumb.png\",\"contentUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/anxeventaday28of31trackingfailedpagecomp\\\/0fac01f5\\\/image_thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Administration\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/database-administration\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"An XEvent a Day (28 of 31) – Tracking Page Compression Operations\"}]},{\"@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 (28 of 31) - Tracking Page Compression Operations - 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-28-of-31-tracking-page-compression-operations\/","og_locale":"en_US","og_type":"article","og_title":"An XEvent a Day (28 of 31) - Tracking Page Compression Operations - Jonathan Kehayias","og_description":"The Database Compression feature in SQL Server 2008 Enterprise Edition can provide some significant reductions in storage requirements for SQL Server databases, and in the right implementations and scenarios performance improvements as well.  There isn\u2019t really a whole lot of information about the operations of database compression that is documented as being available in the […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/","og_site_name":"Jonathan Kehayias","article_published_time":"2010-12-28T20:25:00+00:00","article_modified_time":"2017-04-13T16:16:35+00:00","og_image":[{"url":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday28of31trackingfailedpagecomp\/0fac01f5\/image_thumb.png","type":"","width":"","height":""}],"author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"An XEvent a Day (28 of 31) – Tracking Page Compression Operations","datePublished":"2010-12-28T20:25:00+00:00","dateModified":"2017-04-13T16:16:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/"},"wordCount":751,"commentCount":1,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/#primaryimage"},"thumbnailUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday28of31trackingfailedpagecomp\/0fac01f5\/image_thumb.png","articleSection":["Database Administration","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-28-of-31-tracking-page-compression-operations\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/","name":"An XEvent a Day (28 of 31) - Tracking Page Compression Operations - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/#primaryimage"},"thumbnailUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday28of31trackingfailedpagecomp\/0fac01f5\/image_thumb.png","datePublished":"2010-12-28T20:25:00+00:00","dateModified":"2017-04-13T16:16:35+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-28-of-31-tracking-page-compression-operations\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/#primaryimage","url":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday28of31trackingfailedpagecomp\/0fac01f5\/image_thumb.png","contentUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday28of31trackingfailedpagecomp\/0fac01f5\/image_thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-28-of-31-tracking-page-compression-operations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Database Administration","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/database-administration\/"},{"@type":"ListItem","position":3,"name":"An XEvent a Day (28 of 31) – Tracking Page Compression Operations"}]},{"@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\/536","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=536"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/536\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}