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
  2. Luis Martin Moderator

  3. irxn New Member

    Hi,

    thanks for your answer. The MAXDOP value does not affect normal SELECT statements, am I right?
  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.
  5. irxn New Member

    Hi,

    ok, I understand. Thanks for your help. Have a nice weekend

Share This Page