Now that we have explored the possibilities that memory-optimized tables offer, it would be fantastic to be able to somehow evaluate our existing databases. Ideally this evaluation would show how many tables or stored procedures could potentially be converted from traditional disk-based objects into ultra-fast memory-optimized objects.
Luckily for us, Microsoft has also provided us with some help here too. Inside SQL Server Management Studio are two interesting standard reports that help us to analyze our databases and see how we can benefit from the memory-optimized objects.
The first report is the Transaction Performance Analysis Overview. This report allows us to quickly identify possible candidates ...