Bufferpool Extension Configuration

— Buffer Pool Extension einschalten
ALTER SERVER CONFIGURATION

SET BUFFER POOL EXTENSION ON
(FILENAME = ‚c:\test.bpe‘, SIZE = 15GB );

 

— Konfigurationseinstellungen der BPE anzeigen
SELECT * FROM sys.dm_os_buffer_pool_extension_configuration;

 

— Buffer Pool Extension Datenseiten überwachen
SELECT * FROM sys.dm_os_buffer_descriptors;

 

— Buffer Pool Extension ausschalten
ALTER SERVER CONFIGURATION
SET BUFFER POOL EXTENSION OFF;

Source https://www.sqlxpert.de/sql-server-mehr-performance-durch-in-memory-capabilities-erweiterungen/