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.

	[DatabaseName] =
	CASE [database_id]
		WHEN 32767 THEN 'Kaynak DB'
		ELSE DB_NAME([database_id])
   ,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.


Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!