INFORMATICS

The Best

MSSQL SERVER – Script to Identify Memory Used By Each Database

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 
MSSQL SERVER – Script to Identify Memory Used By Each Database

-- Memory used by each database SELECT DB_NAME(database_id), COUNT (1) * 8 / 1024 AS MBUsed FROM sys.dm_os_buffer_descriptors GROUP BY database_id ORDER BY COUNT (*) * 8 / 1024 DESC GO

Search