Post reply

Buffer pool extensions on shared SSD

  • October 8, 2015 at 11:52 am

    #321182

    Has anyone had any experience with extending the buffer pool onto an SSD drive that is shared ? For instance, if we had a mirrored system drive(The C logical partition) on SSD's, can we use the remaining space on that mirrored partition to extend my SQL 2014 buffer pool ? I understand that in this scenario, there is some competition for the I/O throughput between SQL Server's extended buffer pool and the OS. We intend to have the pagefile on a different disk, other than this specific SSD.

  • October 12, 2015 at 3:59 pm

    #1832890

    For those interested - I got the answer from my posting on the MSDN forums, from a Microsoft employee(so I think it's legit :-)).

    The short answer is yes, the buffer pool can be extended to an SSD in use by something else, as long as there is space on it. The long answer is, well, long winded so I wont go into it here.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply