memory configuration

I like someone to double check with the memory configuration so I know I am good to go.

We have a IBM e-server with 1 CPU dual core and 6 Gbytes of RAM. CPU is one Xeon 2.80 Ghz dual core.

We have W2k3 sp2 standard edition and SQL 2K5 Standard edition.

In our boot.ini file, I have these two switches entered, /PAE /3GB. In SQL 2K5 memory configuration, I have min server memory set to 1024 and maximum server memory set to 3072. Did I set up correctly since I can only use up to 4 Gbytes?

wingman

This is a new server and hasn't been put in production yet, but it will be in 3 days.

quote:Originally posted by satya

Do you have any performance issues with the current setup?>

Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

is your server rinnoing 64bit version of windows or 32bit. as far as i remember the maximum amaount of memory windows server 2003 standard x386 is only 4gb see here. i fyou are running the x64 version then the limit is much higher. to use more than 4 gb ram in a x386 version of windows upi will need to upgrade to enterprise

Thank for the information. The tool will help me a lot. But I just want to know your thought about the switch I put in the boot.ini in my orginial email.

By having 6 Gbytes of RAM in the server, I will waste two 2 Gbytes since I am using Win 2K3 standard version. By using /PAE /3GB switches and min ser mem = 1024G and max ser mem =3072 in SQL memory configruation , SQL 2k5 can use up to 3 Gbytes of RAM. Am I correct on this? Should I not set the min and max and just let SQL dynamically assign? The server is only for SQL server and no other applicaitons.

quote:Originally posted by satya

Have you staged your application & database on this server?
If not you can take help ofhttp://support.microsoft.com/kb/231619 SQLIOSIM to simulate such performance related information to check whether it can copeup or not.

Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

It is windows 2K3 standard wtih 32 bit. I posted another reply so please read that as well.

quote:Originally posted by alexboy456

is your server rinnoing 64bit version of windows or 32bit. as far as i remember the maximum amaount of memory windows server 2003 standard x386 is only 4gb see here. i fyou are running the x64 version then the limit is much higher. to use more than 4 gb ram in a x386 version of windows upi will need to upgrade to enterprise