SQL SERVER – Data Pages In Memory Buffer Pool – sys.dm_os_buffer_descriptors

(Pinal Dave) Recently I was working with a client on Comprehensive Database Performance Health Check and we discovered that they are struggling with Memory issues. During the health check, we reached the point where we needed a investigate the data in memory for a single database.