April 15, 2013 at 2:29 pm
you can use AWE with 32bit SQL on a 64bit OS.
---------------------------------------------------------------------
April 23, 2013 at 7:32 am
Just in case, because the article is not very clear on this point, if you enable AWE in the SQL Server instance you should absolutely set max server memory using sp_configure:
EXEC sys.sp_configure
@configname = 'max server memory (MB)',
@configvalue = ####; -- something sensible that leaves memory for the OS to operate
GO
RECONFIGURE;
GO
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 8:26 am
along with AWE, you have to use PAE in boot.ini to reveal physical ram more than 16gb.
April 23, 2013 at 11:20 am
SQL Show (4/23/2013)
along with AWE, you have to use PAE in boot.ini to reveal physical ram more than 16gb.
PAE is not a valid boot.ini configuration on 64-bit OSes.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply