question

Gergav33 avatar image
Gergav33 asked

dbcc memorystatus

Hi,

I am looking at a 32 bit server with 32gb of ram with AWE set and the boot.ine set properly, When I run DBCC memorystatus I see the following,

why is the vm reserved so low ?

Memory Manager      KB 
VM Reserved      1671608
VM Committed        310744
AWE Allocated       27852800
Reserved Memory     1024
Reserved Memory In Use  0
sql-server-2005dbccawe
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Oleg avatar image
Oleg answered

VM reserved is simply the overall amount of virtual address space the server has reserved. Just because your box has 32 GB does not mean that the SQL Server needs to use all of it if it believes that 1.6 GB is enough for the time being. It will reserve more when it needs to up to the limit you set.

Reserved Memory column shows how much the server has reserved for DAC, and 1 MB is default. Reserved Memory In Use shows 0 because you are not using DAC.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.