SQL Server: Script to find Memory Utilization for each database

This is one of the most important script for SQL Server Database Administrator.
In this post, I am sharing TSQL script to find memory utilization for each SQL Server database.

Generally, The majority percentage of the memory is utilized by the SQL Server buffer pool.

As a Database Administrator, this is our responsibility to find which database is consuming the most buffer pool memory.

We can use sys.dm_os_buffer_descriptors DMV to find information on every cached page of the Buffer pool.

Anvesh Patel

Leave a Reply

1 Comment on "SQL Server: Script to find Memory Utilization for each database"

Notify of
avatar
Sort by:   newest | oldest | most voted
marni
Guest

thank you for sharing this

wpDiscuz