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)
Sign in to queue

Description

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.

Day:

2

Session Type:

Breakout

Code:

DBI-B281

Room:

Room 352D

Embed

Download

Right click to download this episode

The Discussion

Add Your 2 Cents