I received a very interesting question from my client. The question was about how to list all the Memory Optimized Tables in TempDB.
After looking at the execution plan, I realized it was actually built for a very simple query. Today let us discuss Memory-Optimized TempDB and Performance.
I suggest that you try out my Free Video Courses Analyzing SQL Server Query Plans while we work from home this April 2020.
I also discover new aspects of SQL Server. One of DBA recently asked is there any way to capture the execution plan for the canceled query.
Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan while working on Comprehensive Database Performance Health Check.
Recently I got a very unique situation where I had to Remove All Query Cached Plans Not Used In Certain Period. Let us learn about that today.
One of the most appreciated tips was about how to get Last Query Cost in MySQL using the command SHOW STATUS LIKE ‘Last_Query_Cost’.