For example, the following query will return the amount of data cache usage in MB per database:
SELECT count(*)*8/1024 AS 'Cached Size (MB)'
WHEN 32767 THEN 'ResourceDb'
END AS 'Database'
GROUP BY db_name(database_id) ,database_id
ORDER BY 'Cached Size (MB)' DESC
Monitoring SQL Server’s buffer pool is a great way to look out for memory pressure
size of the buffer pool.
size for the buffer pool.
seconds, that SQL Server expects a page that has been loaded into the buffer pool to remain in cache.