A quick look at: sys.dm_os_buffer_descriptors
- by fatherjack
SQL Server places data into cache as it reads it from disk so as to speed up future queries. This dmv lets you see how much data is cached at any given time and knowing how this changes over time can help you ensure your servers run smoothly and are adequately resourced to run your systems. This dmv gives the number of cached pages in the buffer pool along with the database id that they relate to: USE [tempdb]
GO
SELECT COUNT(*) AS cached_pages_count ,
CASE database_id
...(read more)