Hi all, My environment is SQL 2000 enterprise edition, Windows 2003 Enterprise Edition, 12 CPU and 8 GB RAM. I have done below. 1. Added /3GB /PAE in boot.ini 2. AWE Enabled with min server memory 2 GB and Max server Memory 4 After enabling AWE in SQL server, applications were frequently disconnecting. I have tried to open Task Manager, unfortunately windows did'nt open Task Manager. I have faced performance issues in SQL server. Applications are located outside the SQL server. Server is dedicated to SQL and windows is occupying less than 1 GB ram only. Please some body let me know the solution.
Adding the 3/GB switch and PAE may cause problems. You are only allowing the kernel to have 1GB of ram. Read this article. http://russkaufmann.spaces.live.com/Blog/cns!1pwuGkyvTDx37q1_Y3JQ_E6g!229.entry
