How to see what is in your buffer cache

If you have ever wondered what database or tables/indexes were consuming the most memory/buffer in your database, this post can help with that. How do I see this? The key DMV’s to view this  are sys.dm_os_buffer_descriptors, sys.allocation_units, and sys.partitions.  The key piece to identifying what is currently in the buffer cache is sys.dm_os_buffer_descriptors.  The use […]

Read More