Does SSS Buffer Pool Extension still makes sense if database is already on SSD?
If your entire SQL Server database is on SSD already does having a buffer pool extension on SSD still give any additional benefit?
September 11th, 2015 4:14pm
No. the sole case for BPE is when the BPE storage is significantly faster the where the mdf and ndf are.
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 5:03pm
It's looking a bit like this buffer pool extension was added in anticipation of new kinds of memory becoming available over the next year or two, XPoint memory from Intel configured as System Class Memory (SCM), slower than regular DRAM but faster than flash/SSD memory.
... and even then there will be some question as to whether it makes sense, if the main database is in SSD, or the new kinds of flash storage that may also reside directly on the memory bus.
Josh
September 11th, 2015 10:06pm
This topic is archived. No further replies will be accepted.
Other recent topics
