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

    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
    Can I use the default settings (Automatically set I/O affinity and processer affinity)? Or should I change something here?

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

  3. irxn New Member


    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


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

Share This Page