SQL Server Performance

SQL Enterprise on Win 2K Standard

Discussion in 'Performance Tuning for Hardware Configurations' started by sftey1, Jun 30, 2005.

  1. sftey1 New Member

    Just installed a SQL Enterprise edition running on Win2K Standard edition. Turn on AWE and managed to configure max server memory to 2.8 GB. Recycled the server and found no error. Question here is do I need to place the /3GB switch at boot.ini ? Do you think this is correct ?
  2. satya Moderator

  3. derrickleggett New Member

    Satya is correct. You would need Windows 2000 Advanced Server. This might be a good opportunity for an upgraded to Windows 2003. It performs better anyway.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  4. gurucb New Member

    No it will not work.

    To check it use perfmon and in process check for Virtual byts Max and it will be equal to 2Gigs
  5. sftey1 New Member

    Use PERFOMANCE MONITORING, Total Server Memory counter in SQLServer:MemoryManager object shows 2.8GB.

Share This Page