Not every workload can benefit from In-Memory tables. Memory Optimized Tables are not a magic bullet that will improve performance for all kinds of transactional workloads. Therefore, it is very critical that you test & benchmark in-memory performance for your SQL deployments before you decide to migrate disk-based tables to memory-optimized tables. In this session, you will learn:
a. Baselining current performance
b. How to identify the right candidates for In-Memory
c. Generate sample production data
d. Create simulated production workload
e. Test & benchmark In-Memory performance with simulations
f. Compare In-Memory performance with the baseline
You will also learn about a verity of tools and techniques that can be used in our proof-of-concept.
Presented by Amit Bansal at SQLBits 2017