Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

sys.dm_os_buffer_pool_extension_configuration (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Returns configuration information about the buffer pool extension in SQL Server. Returns one row for each buffer pool extension file.

Applies to: SQL Server (SQL Server 2014 through current version).

Column name

Data type

Description

path

nvarchar(256)

Path and file name of the buffer pool extension cache. Is not nullable.

file_id

int

ID of the buffer pool extension file. Is not nullable.

state

int

The state of the buffer pool extension feature. Is not nullable.

0 - Buffer pool extension disabled

1 - Buffer pool extension disabling

2 - Reserved for the future use

3 - Buffer pool extension enabling

4 - Reserved for the future use

5 - Buffer pool extension enabled

state_description

nvarchar(60)

Describes the state of the buffer pool extension feature. Is nullable.

0 = BUFFER POOL EXTENSION DISABLED

1 = BUFFER POOL EXTENSION ENABLED

current_size_in_kb

bigint

Current size of the buffer pool extension file. Is not nullable.

Requires VIEW SERVER STATE permission on the server.

The following example returns all columns from the sys.dm_os_buffer_pool_extension_configruation DMV.

SELECT path, file_id, state, state_description, current_size_in_kb
FROM sys.dm_os_buffer_pool_extension_configuration;

The following example returns the number of cached pages in each buffer pool extension file.

SELECT COUNT(*) AS cached_pages_count
FROM sys.dm_os_buffer_descriptors
WHERE is_in_bpool_extension <> 0
;

Community Additions

ADD
Show:
© 2015 Microsoft