Buffer Pool Extension

GPTKB entity

Statements (23)
Predicate Object
gptkbp:instanceOf SQL Server feature
gptkbp:benefit workloads with high read activity
gptkbp:capacity 32 times physical memory
gptkbp:compatibleWith gptkb:SQL_Server_Express_Edition
gptkb:SQL_Server_on_Linux
dirty pages
gptkbp:configuration ALTER SERVER CONFIGURATION
gptkbp:hasFeature dynamically
https://www.w3.org/2000/01/rdf-schema#label Buffer Pool Extension
gptkbp:improves read performance
I/O throughput
gptkbp:introducedIn gptkb:SQL_Server_2014
gptkbp:minimumSize at least 4 GB
gptkbp:monitors sys.dm_os_buffer_descriptors
sys.dm_os_buffer_pool_extension_configuration
gptkbp:notRecommendedFor systems with slow SSDs
gptkbp:numberOfLocations clean pages only
gptkbp:purpose extend buffer pool to non-volatile storage
gptkbp:requires SSD with high IOPS
gptkbp:requiresRestart No
gptkbp:supports SSD as extension device
gptkbp:bfsParent gptkb:SQL_Server_2014
gptkbp:bfsLayer 7