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 benchmark & test in-memory performance for your SQL deployments before you decide to migrate disk-based tables to memory-optimized tables. In this video, 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 your proof-of-concept.

Keywords:

Important Links:

Follow SQLMaestros on Twitter

Click Here

Follow Amit Bansal on Twitter

Click Here

Subscribe To Newsletter

Click Here

SQLMaestros Video Courses

Click Here

SQLMaestros Hands-On-Labs

Click Here

Subscribe to Amit Bansal’s exclusive distribution list

Click Here

Join us on Telegram

Click Here