How Much RAM Does Which Database Use in SQL Server?
Hello everyone,
In this article, I will try to give information about which database uses how much RAM in SQL Server.
In SQL Server, you may want to know how much RAM each database uses in some cases.
You can easily do this using the code below.
SELECT
[DatabaseName] =
CASE [database_id]
WHEN 32767 THEN 'Kaynak DB'
ELSE DB_NAME([database_id])
END
,COUNT_BIG(*) [Pages in Buffer]
,COUNT_BIG(*) / 128 [Buffer Size in MB]
FROM sys.dm_os_buffer_descriptors
GROUP BY [database_id]
ORDER BY [Pages in Buffer] DESC;Good luck to everyone in business and life.
168 Views
