SQL Server 2014 introduced Buffer Pool Extensions, but the questions remain what is it, how does it work and how can I use it. Together we will answer these questions and more, to help you decide when you should consider making use of this feature to enhance your systems performance. I will help explain why we have this feature, how it works and when you should look to make use of it. Looking at which other SQL Server features it works well with and how to tell how much use it is getting. By the end of this session you will be confident in your ability to decide if and when you need this capability.
John currently works as a SQL Server Premier Field Engineer for Microsoft, supporting and advising a wide array of customers on how to get the best out of their SQL Server systems.
Working with SQL Server for over six years on all versions from SQL 2000 to 2014, I have accumulated a lot of experience in Ops, Development and BI roles that help me get the most out of SQL Server.