|
SQL Server Administration: Available in SQL Server 2014 Enterprise Edition
and Standard Edition x64 only.
Buffer Pool Extension is a way to use solid state disks (SSD) as nonvolatile RAM (NvRAM) instead of memory. It reduces latency. It stores clean or committed pages only, so there is no risk of data loss, and will give faster access to data that would have otherwise been slow because it would have to be read from disk. Buffer Pool Extension can provide performance gains for read-heavy OLTP workloads.
Turn on Buffer Pool Extension in SQL with an ALTER SERVER statement. FILENAME is the path to the bpe file that will be located on the SSD disk and SIZE is the size of the bpe file in GB.
ALTERSERVER CONFIGURATION
SETBUFFERPOOL EXTENSION ON
(FILENAME='X:\BPESSD\EXTENDMEMORY.BPE', SIZE = 50 GB)
SQLRx has worked hard to minimize the impact of monitoring SQL Servers to the point that we are able to monitor high transaction systems with little impact (1% load) on the target system. Contact us today to help you monitor your SQL servers!
| 
