Is there a way how to find out what is cached in SQL Server 2008 R2? I have found the following nice article: http://blog.sqlauthority.com/2010/06/17/sql-server-data-pages-in-buffer-pool-data-stored-in-memory-cache . However, I would like to know how much data (e.g. in percentage and KB) are stored of each table and index. Is there some simple way how to obtain such data?
Sql-server – How to see what is cached in memory in SQL server 2008
memorysql serversql-server-2008
Related Question
- Sql-server – SQL Server 2008 Multi Page Allocation
- Sql-server – SQL Server Dynamic Memory management
- Sql-server – SQL Server Internal Memory Pressure
- Sql-server – SQL server Memory components
- SQL Server Memory – Preventing Usage Over Max Limit
- Sql-server – SQL Server 2008 R2 Standard Edition not using more than 32GB for BufferPool
- Sql-server – Why SQL Server Standard 2017 is using more memory than limit described in documentation
- SQL Server 2008 R2 Memory – Do I Need to Add More Memory?
Best Answer
You can find whats stored in the buffer pool (data cache) using below query :
From here :
Excellent reference : Inside the Storage Engine: What’s in the buffer pool? by Paul Randal.