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

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter