November 13, 2006 at 2:27 pm
Hi - I have a two node cluster running Standard 2005 on Windows 2003 Entp edition. Has 8 GB of memory total. Is setting the AWE, PAE, and /3GB switches the same on SQL 2005 as for 2000? I haven't run into any info on it yet and was just curious.
Thanks,
-Mike
November 13, 2006 at 5:30 pm
PAE and /3GB are on windows level
AWE is for SQL Server and its the same as SQL 2005.
November 14, 2006 at 2:39 am
If you are running 32-bit, everything is the same. Just as in SQL2000, the only aspect of SQL2005 that can take advantage of AWE memory is the database buffer pool.
If you are running 64-bit you do not need any of these items.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply