During my recent Comprehensive Database Performance Health Check, we had implemented quite a few improvements in the database. After making the improvements in the database, we reached to the point where we needed to clear the cache of the server to see how our improvements fairs with the changes which we have made.
SQL SERVER – Finding The Oldest Query Plan From Cache
Often people ask where do I come up with a new blog idea everyday. Well, answer is that I am not the one who comes up with new idea, it is all of you who inspire everyday with a new idea. Recently one of the healtch check client Comprehensive Database Performance Health Check asked me if there is anyway can see the oldest query plan from the cache for his server.
How to Find Queries Using an Index From SQL Server Plan Cache? – Interview Question of the Week #195
Question: How to Find Queries Using an Index From SQL Server Plan Cache?
SQL SERVER – 2017 – Script to Clear Procedure Cache at Database Level
When my customer ask they want to clear the cache of the database, I always so NO. It is not necessary. However, I have come to the realization that customers are always right and sometimes even though I say no, they still want to do it. One way or another way, they will eventually do what they want. Let us learn about Script to Clear Procedure Cache at Database Level.
SQL SERVER – How to Clear Plan Cache with Database Scoped Configuration?
Question: How to Clear Plan Cache with Scoped Configuration?
Heimdall Data Auto-Caching for SQL Server – No Changes to Application
I found a unique caching solution that accelerates SQL Server. Heimdall Data auto-caches and auto-invalidates, removing complex configuration. It requires zero changes to your application and database. Try out the best possible solution for auto-caching.
How to Find SQL Server Memory Use by Database and Objects? – Interview Question of the Week #121
Question: How to Find SQL Server Memory Use by Database and Objects?