when AWE need to enable in SQL Server. SQL Server supports Address Windowing Extensions (AWE) allowing use of physical memory over 4 gigabytes (GB) on 32-bit versions of Microsoft Windows operating systems. but if my Physical memory is 65 GB then we need AWE memory enable ???? I am very confuse, Please tell me when we do enable AWE memory in SQL Server.
What is your operating system? Windows Server 2003 or 2008? 64 bit or 32? Same for your version and edition of SQL. If you are on a 64 bit OS and 32 bit SQL then AWE should be all you need. If you are on 32 bit OS then you may need to enable the 3g switch as well. All is very well documented online. If your OS and SQL are 64bit then you are all good.