September 5, 2007 at 7:33 pm
Does same rules apply for SQL Server 2005 also by using /3Gb and /PAE switches?
Can we use /3gb switch for SQL Server 2005 with more than 3GB?
Any reply is greatly appreciated?
September 7, 2007 at 3:35 am
the OS is still the same so the rules for configuring memory still apply.
main difference in SQL 2005 vs sql2000 is standard edition can now take advantage of memory above 2GB and sql can handle memory dynamically if you enable AWE
HTH
---------------------------------------------------------------------
September 7, 2007 at 3:38 am
If you run SQL Server 2005 32-bit on a 32-bit OS, the same rules apply as for SQL Server 2000 32-bit for /3GB, /PAE in the OS and AWE in SQL. However SQL Server 2005 Standard Edition can use AWE whereas SQL Server 2000 Standard Edition can not.
If you run SQL Server 2005 32-bit on a 64-bit OS, then /3GB and /PAE in the OS do nothing, and likewise AWE in SQL Server does nothing. This means that SQL Server 2005 32-bit on a 64-bit OS is limited to 2GB memory. Period.
If you run SQL Server 2005 64-bit on a 64-bit OS, then /3GB and /PAE in the OS are not relevant, and likewise AWE in SQL Server is not relevant. SQL Server 2005 64-bit on a 64-bit OS can access all the memory available to Windows without any further tweaking.
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