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 ?
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.
answered May 19 '10 at 12:38 PM