SQL Server Performance

SQL AWE is leads issues

Discussion in 'General DBA Questions' started by sramesh, Aug 1, 2009.

  1. sramesh New Member

    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.
  2. imSQrLy New Member

    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

Share This Page