DBCC memory status

sakuraime 2,326 Reputation points
2020-11-09T16:17:18.217+00:00

what's the difference between pages_kb and virtual_memory_committed_kb ??????
38290-capture.jpg

38461-capture2.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,999 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. m 4,271 Reputation points
    2020-11-10T02:37:16.16+00:00

    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:
    38639-dbccmemorystatus.jpg

    sys.dm_os_memory_clerks:
    38644-20201110memoryclerk.jpg

    More information: sys-dm-os-memory-clerks-transact-sql

    BR,
    Mia


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  2. Shashank Singh 6,251 Reputation points
    2020-11-10T06:01:33.913+00:00

    You have already asked the same question in This Thread and similar kind of question On this MSDN thread. I believe you might not keep track on your old thread but you just asked similar question on this QA platform. Kindly avoid this. if you have doubt feel free to ask question on original thread and if you are happy please mark answer and close thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.