Environment: Windows 2008 32 bit, SQL 2005 with SP3 32 bit Standard edition, 24 GB RAM
Need some clarification please. I know that using AWE - SQL Server can access more RAM than 4 GB using locked pages for caching etc. I also know the fact that for more than 16 GB of RAM usage the combination of PAE and AWE are required.
However my question is related to PAE:
a) If only PAE is enabled - Will SQL Server 2005 use more memory than 4 GB?
b) From Control Panel - System - I see 24 GB of RAM and this is an indication that PAE is enabled. Is that correct? Or is there any other way to check if PAE is enabled on the system.
c) From SQL Server Properties - I can see that SQL Server minimum and maximum memory are editable and one can change the minimum and maximum RAM. However AWE is not enabled at this time. Will SQL use the amount or RAM specified in min and max Example: say 6 GB min and 10 GB max? If it will not use the >4GB memory specified (assuming PAE is enabled but AWE is NOT enabled) then why are those two controls editable?
follow me on twitter: http://twitter.com/mohantaneja
View Complete Post