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

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


"CD" <crbd98@yahoo.com> wrote in message
news:4cd2634c-f470-4f0f-aa07-20ed8108ba78@u6g2000prc.googlegroups.com...
> 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

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:31am, "vinu" <vinu.t.1...@gmail.com> wrote:
> 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
>
> "CD" <crb...@yahoo.com> wrote in message
>
> news:4cd2634c-f470-4f0f-aa07-20ed8108ba78@u6g2000prc.googlegroups.com...
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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

"CD" <crbd98@yahoo.com> wrote in message
news:a0c2afe4-8373-414c-9588-cb2d2f361603@w39g2000prb.googlegroups.com...
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
>
> 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
>
> "CD" <crb...@yahoo.com> wrote in message
>
> news:4cd2634c-f470-4f0f-aa07-20ed8108ba78@u6g2000prc.googlegroups.com...
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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


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


"CD" <crbd98@yahoo.com> wrote in message
news:4cd2634c-f470-4f0f-aa07-20ed8108ba78@u6g2000prc.googlegroups.com...
> 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

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

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"CD" <crbd98@yahoo.com> wrote in message
news:4cd2634c-f470-4f0f-aa07-20ed8108ba78@u6g2000prc.googlegroups.com...
> 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