dbcc memorystatus


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

more ▼

asked May 19, 2010 at 12:01 PM in Default

avatar image

61 4 4 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered May 19, 2010 at 12:38 PM

avatar image

20.3k 3 7 29

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 19, 2010 at 12:01 PM

Seen: 2901 times

Last Updated: May 19, 2010 at 12:06 PM

Copyright 2018 Redgate Software. Privacy Policy