{"id":4124,"date":"2014-11-19T07:49:00","date_gmt":"2014-11-19T06:49:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/"},"modified":"2014-11-19T07:49:00","modified_gmt":"2014-11-19T06:49:00","slug":"sql-server-2014-buffer-pool-extension-a-corruption","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/","title":{"rendered":"SQL Server 2014: buffer pool extension & corruption"},"content":{"rendered":"

I had the opportunity to attend Paul Randal\u2019s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension (BPE). As you probably know, BPE only deals with clean pages. Paul hesitated a lot and asked us to test and this is exactly what I will do in the blog post.<\/p>\n

First, let\u2019s start by limiting the maximum memory that can be used by the buffer pool:<\/p>\n

— Configure SQL Server max memory to 1024 MB<\/span><\/div>\n
EXEC sp_configure‘show advanced options’, 1;<\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
GO<\/span><\/div>\n
RECONFIGURE;<\/span><\/span><\/div>\n
EXEC sp_configure‘max server memory (MB)’, 1024;<\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
GO<\/span><\/div>\n
RECONFIGURE;<\/span><\/span><\/div>\n
GO<\/span><\/div>\n

Then we can enable the buffer pool extension feature:<\/p>\n

ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION<\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
ON<\/span><\/div>\n
(<\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 — change the path if necessary<\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FILENAME = N’E:SQLSERVERMSSQLSERVERDATAssdbuffer_pool.bpe’,<\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SIZE = 4096 MB<\/span><\/span><\/span><\/div>\n
);<\/span><\/div>\n

I configured a buffer pool extension size with 4X the max memory value for the buffer cache<\/p>\n

At this point I need a database with a big size in order to have a chance to retrieve some data pages in the buffer pool extension part. My AdventureWorks2012 database will fit this purpose:<\/p>\n

USE AdventureWorks2012;<\/span><\/span><\/span><\/div>\n
GO<\/span><\/div>\n
\u00a0<\/span><\/div>\n
EXEC sp_spaceused;<\/span><\/span><\/span><\/span><\/div>\n

 <\/p>\n

\"blog_23_-_1_-_adventureworks2012_size\"<\/p>\n

I have also 3 big tables in this database: dbo.bigTransactionHistory_rs1 (2.2GB), dbo.bigTransactionHistory_rs2 (2.1 GB) and BigTransactionHistory (1.2GB)<\/p>\n

\"blog_23_-_2_-_adventureworks2012_top_tables_size\"<\/p>\n

I have a good chance to find out some pages related on these tables in the BPE, if I perform a big operation like a DBCC CHECKDB on the AdventureWorks2012 database.<\/p>\n

After performing a complete integrity check of this database and executing some queries as well, here it is the picture of my buffer pool:<\/p>\n

SELECT<\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CASE is_in_bpool_extension<\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHEN 1 THEN ‘SSD’<\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ELSE ‘RAM’<\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 END AS location,<\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COUNT(*) AS nb_pages,<\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COUNT(*) * 8 \/ 1024 AS size_in_mb,<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COUNT(*) * 100. \/(SELECT COUNT(*) FROM sys.dm_os_buffer_descriptors(nolock)) AS percent_<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
FROM sys.dm_os_buffer_descriptors(nolock)<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
GROUP BY is_in_bpool_extension<\/span><\/span><\/span><\/div>\n
ORDER BY location;<\/span><\/span><\/span><\/span><\/div>\n

 <\/p>\n

\"blog_23_-_21_-_buffer_pool_overview\"<\/p>\n

Is it possible to find some pages in the buffer pool extension part that concerns the table bigTransactionHistory_rs1?<\/p>\n

SELECT<\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 bd.page_id, da.page_type, bd.is_modified<\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
FROM sys.dm_os_buffer_descriptors AS bd<\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 JOIN sys.dm_db_database_page_allocations(DB_ID(‘AdventureWorks2012’), OBJECT_ID(‘dbo.bigTransactionHistory_rs1’), NULL, NULL, DEFAULT) AS da<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON bd.database_id = da.database_id<\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND bd.file_id = da.allocated_page_file_id<\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND bd.page_id = da.allocated_page_page_id<\/span><\/span><\/span><\/span><\/span><\/div>\n
WHERE bd.database_id = DB_ID(‘AdventureWorks2012’)<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND bd.is_in_bpool_extension = 1<\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND da.page_type IS NULL<\/span><\/span><\/span><\/span><\/span><\/div>\n

 <\/p>\n

\"blog_23_-_3_-_bigTransactionHistory_rs1_pages\"<\/p>\n

I chose the first page 195426 and I finally corrupted it<\/p>\n

DBCC WRITEPAGE(AdventureWorks2012, 1, 195426, 0, 2, 0x0000);<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n

\"blog_23_-_4_-_corrupt_page\"<\/p>\n

Then, let’s take a look at the page with ID 195426 to see if it still remains in the BPE:<\/p>\n

SELECT<\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 page_id, <\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 is_in_bpool_extension, <\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 is_modified<\/span><\/div>\n
FROM sys.dm_os_buffer_descriptors AS bd<\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
WHERE bd.page_id = 195426<\/span><\/span><\/span><\/span><\/div>\n

 <\/p>\n

\"blog_23_-_5_-_check_location_page_after_corruption\"<\/p>\n

Ok (fortunately) not \ud83d\ude42 However we can notice that the page has not been tagged as “modified” by looking at the sys.dm_os_buffer_descriptors DMV. Hum my guess at this point is that using DBCC WRITEPAGE is not a classic process for modifying a page but in fact the process used by the BPE extension is not what we can imagine at the first sight.<\/p>\n

Indeed, moving a page from BPE is almost orthogonal to the dirty nature of a page because the buffer manager will move a page into the memory because it becomes hot due to the access attempt. Modifying a page needs first access to the page (a particular thanks to Evgeny Krivosheev – SQL Server Program Manager – for this clarification).<\/p>\n

We can verify if the page with ID 195426 is really corrupted (remember this page belongs to the bigTransactionHistory_rs1 table):<\/p>\n

DBCC CHECKTABLE(bigTransactionHistory_rs1) WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS;<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n

 <\/p>\n

\"blog_23_-_6_-_check_corruption_for_data_page\"<\/p>\n

Note some other corruptions but in this context it doesn’t matter because I performed some other corruption tests in this database \ud83d\ude42
\nSo the next question could be the following: Do you think a corrupted page can be moved from the buffer pool into the memory? \u2026 The following test will give us the response:<\/p>\n

CHECKPOINT<\/span><\/div>\n
GO<\/span><\/div>\n
DBCC DROPCLEANBUFFERS;<\/span><\/span><\/span><\/div>\n
GO<\/span><\/div>\n
— Perform queries in order to full fill the buffer cache and its extension<\/span><\/div>\n

We flush dirty pages to disk and the we clean the buffer cache. Afterward, I perform some others queries in order to populate the buffer cache (memory and BPE) with database pages. At this point we have only clean pages. A quick look at the buffer cache with the sys.dm_os_buffer_descriptor DMV give us the following picture (I recorded into a temporary table each time I found out the page ID 195426 into the buffer cache (either memory or BPE):<\/p>\n

\"blog_23_-_7_-_find_out_a_corrupted_page_in_the_BPE\"<\/p>\n

 <\/p>\n

We can notice that a corrupted page can be part of the buffer pool extension and this is an expected behavior because the page ID 195426 is not dirty or modified but corrupted only at this point.<\/p>\n

Enjoy!<\/p>\n

By David Barbarin<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

I had the opportunity to attend Paul Randal\u2019s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension (BPE). As you probably know, BPE only deals with clean pages. Paul hesitated a lot […]<\/p>\n","protected":false},"author":26,"featured_media":4125,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[440,269,49,506,52],"type_dbi":[],"class_list":["post-4124","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-buffer-pool-extension","tag-corruption","tag-microsoft","tag-pass","tag-sql-server-2014"],"acf":[],"yoast_head":"\nSQL Server 2014: buffer pool extension & corruption - dbi Blog<\/title>\n<meta name=\"description\" content=\"I had the opportunity to attend Paul Randal\u2019s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension (BPE).\" \/>\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-2014-buffer-pool-extension-a-corruption\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2014: buffer pool extension & corruption\" \/>\n<meta property=\"og:description\" content=\"I had the opportunity to attend Paul Randal\u2019s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension (BPE).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-19T06:49:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_23_-_1_-_adventureworks2012_size.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"362\" \/>\n\t<meta property=\"og:image:height\" content=\"84\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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-2014-buffer-pool-extension-a-corruption\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server 2014: buffer pool extension & corruption\",\"datePublished\":\"2014-11-19T06:49:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/\"},\"wordCount\":852,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_23_-_1_-_adventureworks2012_size.jpg\",\"keywords\":[\"buffer pool extension\",\"Corruption\",\"Microsoft\",\"Pass\",\"SQL Server 2014\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/\",\"name\":\"SQL Server 2014: buffer pool extension & corruption - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_23_-_1_-_adventureworks2012_size.jpg\",\"datePublished\":\"2014-11-19T06:49:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"description\":\"I had the opportunity to attend Paul Randal\u2019s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension (BPE).\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_23_-_1_-_adventureworks2012_size.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_23_-_1_-_adventureworks2012_size.jpg\",\"width\":362,\"height\":84},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2014: buffer pool extension & corruption\"}]},{\"@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 2014: buffer pool extension & corruption - dbi Blog","description":"I had the opportunity to attend Paul Randal\u2019s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension (BPE).","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-2014-buffer-pool-extension-a-corruption\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2014: buffer pool extension & corruption","og_description":"I had the opportunity to attend Paul Randal\u2019s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension (BPE).","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/","og_site_name":"dbi Blog","article_published_time":"2014-11-19T06:49:00+00:00","og_image":[{"width":362,"height":84,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_23_-_1_-_adventureworks2012_size.jpg","type":"image\/jpeg"}],"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-2014-buffer-pool-extension-a-corruption\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server 2014: buffer pool extension & corruption","datePublished":"2014-11-19T06:49:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/"},"wordCount":852,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_23_-_1_-_adventureworks2012_size.jpg","keywords":["buffer pool extension","Corruption","Microsoft","Pass","SQL Server 2014"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/","name":"SQL Server 2014: buffer pool extension & corruption - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_23_-_1_-_adventureworks2012_size.jpg","datePublished":"2014-11-19T06:49:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"description":"I had the opportunity to attend Paul Randal\u2019s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension (BPE).","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_23_-_1_-_adventureworks2012_size.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_23_-_1_-_adventureworks2012_size.jpg","width":362,"height":84},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-buffer-pool-extension-a-corruption\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2014: buffer pool extension & corruption"}]},{"@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\/4124","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=4124"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4124\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4125"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4124"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}