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
Power Monitoring Expert
ION Enterprise
ION EEM
Environment
Microsoft SQL Server
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
Released for: Schneider Electric Singapore
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
Power Monitoring Expert
ION Enterprise
ION EEM
Environment
Microsoft SQL Server
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
Released for: Schneider Electric Singapore
Need help?
Start here!
Find answers now. Search for a solution on your own, or connect with one of our experts.
Contact Support
Reach out to our customer care team to receive more information, technical support, assistance with complaints and more.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Search FAQs
Search topic-related frequently asked questions to find answers you need.
Contact Sales
Start your sales enquiry online and an expert will connect with you.
