Sunday, May 24, 2020

SQL Server - Hot & Cold cache in SQL Server

Once I was listening to a performace tunning talk online. The author mention the keywords like “Cold Cache” & “Hot Cache”. As a developer I do not know what they were at that point of time. Further digging I found what this specifies.

Hot Cache: When you want to access the data from DB and it is already present in cache courtersy other query which might have run before that

Cold Cache: The data your query is looking for is not present in cache then we say that cache is cold

No comments:

Post a Comment