Caching SQL Server Tables After Restart

SQL Server Cached Pages and ways to bring data pages to memory
We noticed considerable latency in stored procedure execution after restarting SQL Server Instance which was triggered by accessing data from disk instead of memory. So we ended up writing a simple script to bring data pages to memory. This helped us to avoid first touch penalty after restart in production environment.

Populate SQL Server Cache

Populate SQL Server Cache

Populate Temporary Table with Base Table Data to avoid Physical Reads. This helps to avoid DISK Physical reads after Server or Instance Restart. 

Database Level Cached Pages

Database Level Buffer Pages 

Table Level Cached Pages

Object Level Buffer Pages for a Database

Leave a Reply

Your email address will not be published. Required fields are marked *