x

SQL Server Max Memory

I have a server running Windows 2003 Enterprise (x86) and SQL Server 2005 Enterprise SP.

The sqlserver process currently consumes aorund 1.6GB of memory although there is around 12GB in the sever (the OS only see's 4GB due to 32 bit limitation). To use all this memory will I need to upgrade to a 64bit OS and 64bit SQL Server enterprise?

I have aslo read about using AWE but would like do it do it without that if possible.

more ▼

asked Mar 07 '10 at 03:00 PM in Default

JohnT1000 gravatar image

JohnT1000
39 2 2 2

Can you explain why you wouldn't want to enable AWE?
Mar 08 '10 at 12:51 PM SQL Kiwi
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

To let SQL Server use the majority of that 12GB, you'll need to either use 64-bit or AWE.

But it seems odd that it's stopping at 1.6GB, when 32-bit systems support much more than that. Could it be that your databases are sufficiently small so that 1.6GB is all you need?

more ▼

answered Mar 07 '10 at 10:26 PM

Rob Farley gravatar image

Rob Farley
5.7k 15 18 20

1.6GB seems about right on 32-bit SQL Server running without AWE, assuming that the /3GB switch is not present in boot.ini

2GB VAS minus 384MB for the multi-page allocation region is about 1.6GB.

Paul
Mar 08 '10 at 12:50 PM SQL Kiwi
Ah yes... Not using /3GB either. Why do that?
Mar 08 '10 at 06:11 PM Rob Farley
(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:

x1936
x53
x12

asked: Mar 07 '10 at 03:00 PM

Seen: 1678 times

Last Updated: Mar 07 '10 at 03:00 PM