TransWikia.com

Is Buffer Pool Extension (BPE) needed if my database is already on SSD?

Database Administrators Asked by jyao on October 28, 2021

Here is my simplified scenario, let’s say I have one (and only one) database of 500GB on SQL Server 2016 EE, this database is on SSD drives already (both data and log files), and my server has 64GB memory, I am thinking to add another SSD drive (let’s assume this SSD is of same performance as other SSD drives in the server), and use this new SSD drive for BPE (buffer pool extension) feature, the question is: since my database is already on SSD, does it make sense (or do I get any gain) if I enable BPE in this scenario?

Thanks,
Jeff_yao

One Answer

You should enable BPE and test it using your existing SSD drive(s) first to see if you get any performance improvement at all from BPE. It's going to depend on your workload and waits and if your current SSDs are locally attached as the BPE drive should be.

Answered by MSSQLServerDBA on October 28, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP