{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Schneider Electric USA Website

Welcome to our website.
How can we help you today?
How to Identify the Amount of Memory Used by each Database
Issue
How to identify the amount of memory used by each database from SQL Server for commissioning, sizing and troubleshooting purposes.

Product Line
Struxureware Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x, 8.x, 9.x, 2020
ION Enterprise 6.0. x
ION EEM

Environment
SQL Server 2005, SQL Server 2008 R 2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017

Cause
Determining the memory consumption is required to aid in commissioning systems and/or troubleshooting performance related issues.

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

To retrieve the the amount of memory used by each database of current SQL Server installation, log into SQL Server Management Studio and run the attached SQL script (Memory_Used.sql).
Alternatively, execute the query(s) below :
-- 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

Schneider Electric USA

Attachment(s)
Memory_Used.sql [190 Bytes]
Explore more
Range:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range: