Statements (23)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb: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
|
| 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
|
| https://www.w3.org/2000/01/rdf-schema#label |
Buffer Pool Extension
|