x

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 
more ▼

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

Gergav33 gravatar image

Gergav33
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

Oleg gravatar image

Oleg
15.9k 2 4 24

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1945
x47
x5

asked: May 19, 2010 at 12:01 PM

Seen: 2595 times

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