SQL Server Performance

Best SQL Server properties

Discussion in 'SQL Server 2005 General DBA Questions' started by irxn, Nov 9, 2011.

  1. irxn New Member

    Hi,
    I want to know what are the best settings for my SQL server.
    The Server has 4 Intex XEON CPU with 2,66 GHZ and 32 GB RAM.
    OS: Windows Server 2003 R2 x64
    Database: SQL Server 2005 (9.00.4053.00)
    Memory settings:
    I think I will use 30 GB for maximum server memory, to reserver 2GB for the OS, is this okay?
    Other memory options I leave to default
    Processors:
    Can I use the default settings (Automatically set I/O affinity and processer affinity)? Or should I change something here?

    Advanced:
    Actual the setting for Max Degree of Parallelism is set to 1. Should this value be changed?
    Are there any other settings I should make?
    Thanks for your help,
    Best regards,
    Peter
    irxn, Nov 9, 2011
    #1

  2. Luis Martin Moderator

    Luis Martin, Nov 9, 2011
    #2

  3. irxn New Member

    Hi,

    thanks for your answer. The MAXDOP value does not affect normal SELECT statements, am I right?
    irxn, Nov 10, 2011
    #3

  4. FrankKalis Moderator

    Not sure if I understand you correctly, but when you specify a MAXDOP query hint it will affect even normal SELECT statements.
    FrankKalis, Nov 10, 2011
    #4

  5. irxn New Member

    Hi,

    ok, I understand. Thanks for your help. Have a nice weekend
    irxn, Nov 11, 2011
    #5

Share This Page