How to set server to use all 8GB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CD - 18 Jul 2008 09:05 GMT

Hello All,

I have a server with Windows 2003 Server 32 bit and 10 GB of memory (I
use physical address extension).

I would like to set my SQL Server 2005 server (standard edition) to
use 8GB, instead of the 1.6 max it uses today. I searched the posts
but am still confused. What is the recommended way to accomplish
this? Do I need to enable AWE? Set the min/max server memory?

Thank you
CD

Reply to this Message

vinu - 18 Jul 2008 09:31 GMT

hello

Which edition of windows Server are you using / 32 bit or 64 bit.

SQL Server 32 bit will not be able to access more 4gb of memory . this is
because 32 it pointer cannot hold a memory address larger than 4gb

Also, even if you allocate 4gb for sql server, it doesn't mean that sql
server will use the whole 4gb memory.
for more info see bol on dynamic memory management

vinu

> Hello All,
>
[quoted text clipped - 8 lines]
> Thank you
> CD

Reply to this Message

CD - 18 Jul 2008 09:56 GMT

Hello Vinu,

I am using SQL Server 2005 standard edition 32 bit.

Wouldn't AWE allow SQL Server to recognize more than 4GB?

Cheers
CD

> hello
>
[quoted text clipped - 23 lines]
>
> - Show quoted text -

Reply to this Message

vinu - 18 Jul 2008 10:24 GMT

Cd

ignore my previous post

see the link below
http://msdn.microsoft.com/en-us/library/ms190961.aspx
http://msdn.microsoft.com/en-us/library/ms190673.aspx
http://msdn.microsoft.com/en-us/library/ms179301.aspx

vinu

Hello Vinu,

I am using SQL Server 2005 standard edition 32 bit.

Wouldn't AWE allow SQL Server to recognize more than 4GB?

Cheers
CD

On Jul 18, 1:31 am, "vinu" <vinu.t.1...@gmail.com> wrote:

> hello
>
[quoted text clipped - 27 lines]
>
> - Show quoted text -

Reply to this Message

TheSQLGuru - 18 Jul 2008 14:19 GMT

/PAE in boot.ini. SQL Server configured to use AWE. Reboot to get
everything functional. Now set max memory to use 8GB.

Be sure to monitor paging occassionally to ensure 8GB isn't too high.

Also consider setting Lock pages in memory setting for the sql server
service user account in windows.

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> Hello All,
>
[quoted text clipped - 8 lines]
> Thank you
> CD

Reply to this Message

Andrew J. Kelly - 18 Jul 2008 14:25 GMT

You need to turn on AWE and set your max memory to no more than 8GB.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> Hello All,
>
[quoted text clipped - 8 lines]
> Thank you
> CD

Reply to this Message