SQL Server Performance

Log in or Sign up

memory support for sql 2005 STD 64BIT

Discussion in 'SQL Server 2005 General DBA Questions' started by avipenina, Jan 2, 2008.

avipenina New Member

Hi,
I'm about to install Windows 2003 STD 64BIT and SQL 2005 STD 64BIT with 12GB MEM.
my question is about the switch in the BOOT.INI - do i need to enable any switch with this server configuration?
and do i need to enable the AWE on the SQL?

avipenina, Jan 2, 2008

#2
MohammedU New Member

Memory is OS maximu for EE and SE. I don't think you need enable AWE but make sure lock pages in memory is configured.
check the following...
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1157395,00.html
http://support.microsoft.com/kb/918483

MohammedU, Jan 2, 2008

#3
satya Moderator

For both of 64bit no need to set it up, as it can use all memory on 64-bit server without enable awe and to addup MU refer to http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspx

satya, Jan 3, 2008

#4

(You must log in or sign up to reply here.)

Share This Page