prashanthreddymr (4/17/2013)
Am a junior DBA and We have an issue from last couple of days. We have a server of Windows 2003 Standard Edtion of x64 bit with SP2. SQL Server is of 32bit running. Physical Memory on the server is 0f 4GB and SQL now running out of memory. Can we enable the AWE on a 64 bit OS machine where SQL is of 32 bitPlease suggest me
64-bit Windows with a 32-bit SQL Server instance running on it is not a typical configuration. You do not need to worry about /PAE or /3GB on a 64-bit OS. If you have either in your boot.ini you should
consider removing it. Just set max memory to 3GB for the SQL Server instance. On a 64-bit OS a 32-bit instance of SQL Server can use up to 4GB of memory without any additional configuration:
EXEC sys.sp_configure
@configname = 'max server memory (MB)',
@configvalue = 3072;
GO
RECONFIGURE;
GO
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato