Sys.dm_os_buffer_descriptors (Transact-SQL)

This DMV returns information about all the data pages that are currently in the SQL Server buffer pool. The output of this view can be used to determine the distribution of database pages in the buffer pool according to database, object, or type. 310 more words