How to retrieve queries, not from the cache for MySQL and SQL Server, we discussed SQL_NO_CACHE and OPTION (RECOMPILE). Let us discuss this.
What is the Difference Between sql_handle and plan_handle?- Interview Question of the Week #269
Question: What is the Difference Between sql_handle and plan_handle?
Answer: I was recently asked this question. Let us see the answer today.
SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period
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.Â
SQL SERVER – List All Frequently Ran Stored Procedure From Server Cache
We started working with my Comprehensive Database Performance Health Check service and found very interesting details from the server cache.Â
SQL SERVER – Script to Get Compiled Plan with Parameters From Cache
Lots of people often ask me as I share pretty everything on the blog – Do I have any Business Secrets. Actually, the answer is no, I never keep any secrets. I always share everything I know and I want my customers and readers learn along with me. Today I will share another script which I have written which I frequently use with my consulting engagement Comprehensive Database Performance Health Check.
SQL SERVER – List Query Plan, Cache Size, Text and Execution Count
I love the curious questions from people who attended the class. Here is one such question during recent SQL Server Performance Tuning Practical Workshop. Let us see the question which I received about the Query Plan.
What is Clean Buffer in DBCC DROPCLEANBUFFERS? – Interview Question of the Week #215
Question:Â What is Clean Buffer in DBCC DROPCLEANBUFFERS?