Select type, - type of clerk
sum(virtual_ memory_ reserved_ kb)as vm_ Reserved_ KB, - reserved memory
sum(virtual_ memory_ committed_ kb)as vm_ Committed_ KB, - committed memory
sum(awe_ allocated_ kb)as awe_ Allocated_ KB, - memory used after awe is turned on
sum(shared_ memory_ reserved_ kb)as sm_ Reserved_ KB, - shared reserved memory
sum(shared_ memory_ committed_ kb)as sm_ Committed_ KB, - shared committed memory
sum(single_ pages_ kb)as SinlgePage_ Memory of stolen in KB, - buffer pool
sum(multi_ pages_ kb)as MultiPage_ KB -- memory of memtoleave
FROM sys.dm_os_memory_clerks
GROUP BY type ORDER BYtype
--Query buffer pool / memory to leave
SELECT
sum(virtual_memory_reserved_kb)AS [Reserved],
sum(virtual_memory_committed_kb)AS [Commit],
sum(virtual_memory_reserved_kb)/sum(virtual_memory_committed_kb) AS[Reserved/Commit],
sum(single_pages_kb)+sum(multi_pages_kb) AS [Stolen],
sum(virtual_memory_committed_kb)+sum(single_pages_kb)AS [Buffer Pool],
sum(multi_pages_kb) AS[MemToLeave],
SUM(awe_allocated_kb)AS [AWEAllocated]
FROM sys.dm_os_memory_clerks
--Query SQL server memory usage
select * from sys.dm_os_process_memory
Recommended Today
Why is reids fast
1. What is redis? Redis is completely open source and complies with the BSD protocol. It is a high-performance key value database. Redis is also one of the most popular NoSQL databases at present. It contains a variety of data structures, supports network, is memory based, and has an optional key value pair storage database […]
- Collection and summary of database optimization problems
- SQL_ Usage analysis of server full-text index
- SQL_ Demonstration of using server full-text index
- Solution to the failure to restore SQLSERVER database after backup
- Usage examples of if else in sqlserver stored procedures
- Tips for installing msde2000 for security reasons, the solution requires strong sa password
- How can sqlsql database authorize stored procedures / functions in batches?
- Complete syntax and parameter description of various triggers in SQL Server
- When deleting users in MSSQL, the database principal has a schema in the database. The solution cannot be deleted
- SQLSERVER database syntax Encyclopedia