Hi @sakuraime ,
what's the difference between pages_kb and virtual_memory_committed_kb ??????
pages_kb: Applies to: SQL Server 2012 (11.x) and later.Specifies the amount of page memory allocated in kilobytes (KB) for this memory clerk. Is not nullable.(the result =(single page +multi-page) before 2012 version, but not include the third party code: for example, OLE-DB,xproc )
vitual_memory_committed_kb: Specifies the amount of virtual memory that is committed by a memory clerk. The amount of committed memory should always be less than the amount of reserved memory. Is not nullable.
DBCC memorystautus is a traditional method, and the information provided by DMV is more detailed and accurate. Most of the time their results are consistent.
On my own side test as next:
DBCC MEMORYSTATUS:
sys.dm_os_memory_clerks:
More information: sys-dm-os-memory-clerks-transact-sql
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.