Hi Koteswara Rao,

As it is a 32-bit machine, use

1. PAE Switch -- On windows side

2. AWE -- On SQL Server Side

3. Max Memory Setting -- 25600 MB (25 GB) on SQL Server Side

4. Use Lock pages in Memory (Optional)-- To prevent paging out SQL Server memory pages -- On windows side.

On 64-Bit machine AWE is not needed.

Thank You,

Best Regards,

SQL Buddy