SQL Server Performance

sqlserver sp_configure 'max server memory'

Discussion in 'Performance Tuning for Hardware Configurations' started by rbbc1234, Jul 5, 2005.

  1. rbbc1234 New Member

    Hi,

    I have SQL Server 2000 Enterprise installed on a system with Windows 2003 Server Enterprise and 8 GB of Ram. I want to have sqlserver utilize more than 2 GB of Ram. I'm unable to set 'max server memory' to a figure larger 2147483647. Any ideas as to why this may be?

    rbbc1234, Jul 5, 2005
    #2

  2. Luis Martin Moderator

    Check:

    http://www.sql-server-performance.com/awe_memory.asp

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Jul 5, 2005
    #2

  3. satya Moderator

    satya, Jul 6, 2005
    #2

Share This Page