September 24, 2015 at 4:21 am
Hi,
I am reading about Buffer Pool Extensions, and how it stores data pages on media like an SSD, to speed up retrieval in future. Would this be useless if my mdf files are already on SSD media? At most, I envisage it meaning that instead of grabbing the data from the mdf, it would grab the data from the buffer pool extension drive, but if they are both on SSD's, I'm not sure of how much return I would see.
Has anyone else decided to use BPE when their data is already on SSD's, and have they noticed any improvement in these cases?
September 24, 2015 at 7:05 am
The positive impact when you already have SSDs is probably going to be less, but it will still be there. Primarily because we're talking not about accessing your database files, but about how it's managing memory and dirty pages in memory, taking advantage of SSDs to arrive at a faster method of I/O there. Effectively, it gives you a greater buffer pool by substituting SSDs (what they refer to as non-volatile storage) for actual additional memory through the use of the extension. So yeah, it's going to be better.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply