October 16, 2009 at 6:45 am
Hi,
What are the recommended settings if iam using 64-bit os and sqlserver enterprise edition 2005, and i have 32GB Ram and i want to use 25 GB, could any body help to do settings?
Koteswar Rao
October 16, 2009 at 7:30 am
You needn't worry about AWE as you are using 64-bit .
AWE is a way of allocating more memory to 32-bit systems. It is ignored in 64-bit OSes.
On the memory page of your server proerties you can set the max RAM in MB that SQL Server may use - 25GB * 1024 = 25600MB.
Reastart the SQL server service and away you go.
October 17, 2009 at 2:38 pm
have a good read of this blog:
---------------------------------------------------------------------
October 18, 2009 at 10:19 pm
Hi,
thank you for information , i have one more doubt, when to use awe & pae switch?
Could you please provide information.
Koteswar Rao
October 18, 2009 at 11:49 pm
HI Koteswar Rao,
Use of the /PAE switch in the Boot.ini and the AWE enable option in SQL Server allows SQL Server 2000 to utilize more than 4 GB memory. Without the /PAE switch SQL Server can only utilize up to 3 GB of memory.
FOR more info :
October 19, 2009 at 2:56 am
AWE and /PAE switch are both irrelevant if you have a 64-bit OS. They will be ignored.
You would want to consider using AWE and /PAE only if you are using a 32-bit operating system.
Google AWE or PAE and site:microsoft.com to confirm this.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply