none
DBCC memorystatus() RRS feed

All replies

  • Did you went through this Undersanding DBCC memorystatus output  ?

    VM: means virtual memory

    VM reserved: Means amount of virtual memory SQl Server has reserved, this reservation is based on future calculations. 

    VM committed: Amount of virtual memory committed. A committed memory is one with physical RAM address mapped to it. This means the memory is being utilized at some point of time.

    When a process in SQL Server needs memory. Memory manager first assigns memory from virtual address space(VAS) and looks for region in physical memory to map it to that and make it committed. Once mapped the memory is committed and process can start using it.

    EDIT: Lot of things in DBCC MEMORYSTATUS  is undocumented and you can see no updated document from MS. Its is better to rely on DMV's for memory information.



    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP


    Wednesday, August 1, 2018 9:05 AM
  • VM reserved is fixed size? it include paging space ?

    I see VM reservsed is much larger even than the physical memory of the server

    Wednesday, August 1, 2018 9:47 AM
  • by the way. what's the relationship between memory clerk and memory objects?

    Wednesday, August 1, 2018 9:47 AM
  • VM reserved is fixed size? it include paging space ?

    I see VM reservsed is much larger even than the physical memory of the server

    Ofcourse VM reserved will be larger, it represents VAS in SQL Server. For SQL Server 64 bit system VAS is 8 TB. VAS means total amount of virtual address space. It depends on architecture for 64 bit VAS is 2^64 which comes to some peta byte but since that number is not literally possible now the VAs was limited to 8 TB. I do not think VAs inlcudes paged memory, pages memory is temporary disk area.

    by the way. what's the relationship between memory clerk and memory objects?
    Clerks are one who track memory allocations to various objects. Objects use memory, clerks track how much memory objects have used.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Wednesday, August 1, 2018 9:56 AM
  • thankyou

    VM reserved is around 3.6GB

    VM committed only 16MB

    Means only 16MB use in Physical memory for bufferpool ?

    Thursday, August 2, 2018 2:24 AM
  • thankyou

    VM reserved is around 3.6GB

    VM committed only 16MB

    Means only 16MB use in Physical memory for bufferpool ?

    FYI: You are looking this value for one of the clerk SQLBUFFERPOOL and that to on node 0 so this is only half the info.  Yes as per value, committed at that point of time, is 16 MB and reserved around 3.6 GB which can ofcourse change in future 

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, August 2, 2018 4:45 AM
  • so it's a bit strange , because to SQL server total memory is around up to 4GB already

     total memory  as I know it's the memory used by sql server in PHYSICAL memory for buffer pool,plan cache....etc..

    Thursday, August 2, 2018 6:38 AM
  • so it's a bit strange , because to SQL server total memory is around up to 4GB already

     total memory  as I know it's the memory used by sql server in PHYSICAL memory for buffer pool,plan cache....etc..

    What is strange here VM means virtual memory which is 8 TB and any process in SQl Server can see this 8 TB virtual memory and can reserve accordingly. Physical memory is limited and that is RAM on the system, and when physical memory is mapped to virtual then memory is allocated. The reserved has hardly and correlation with committed, process can reserve as much as it likes but committed is what actual it is using.

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, August 2, 2018 6:50 AM