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


    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?

  2. Luis Martin Moderator



    Luis Martin

    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.

  3. satya Moderator

Share This Page