Microsoft SQL Server 2014 Field Benchmarking In-Memory OLTP and Buffer Pool Extension Features (Doing More with Less)
Play Microsoft SQL Server 2014 Field Benchmarking In-Memory OLTP and Buffer Pool Extension Features (Doing More with Less)
SQL Server 2014 ships with powerful, new features, two of these can really take your performance to the next level are In-Memory OLTP (Codename "Hekaton") and the Buffer Pool Extension (BPE). In-Memory OLTP unleashes today’s powerful processors and removes the roadblocks to new heights in performance. BPE takes advantage of lightning fast storage (in the form of Solid State Storage) to effectively and economically expand the amount of usable memory for the system. These two new features were field benchmarked in the MTC Chicago to gain an understanding on the behavior, scalability, and use cases where these apply. This session reviews the results of the benchmark testing along with customer examples using each feature.