One of the most popular questions I received during my Comprehensive Database Performance Health Check is Finding Queries Using Particular Index.
Yesterday I published a video One Query Many Plans – SQL in Sixty Seconds #171 and I received lots of questions on the topic.
The question I was asked was about a query that had the same result same query plan but the different entry in the cache, is that possible.
Today’s topic is very unique and one should not try it out without the proper consultation of an expert. How to Remove Unused Cache MARK_IN_USE_FOR_REMOVAL.
we had an interesting situation where we wanted to Find the Count of Table Used in Query From Cache. Let us see how we can do that in today’s blog post.