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
|