SQL Server Performance

Recommended OS and SQL editions for new server

Discussion in 'SQL Server 2008 General DBA Questions' started by beauars, May 24, 2009.

  1. beauars New Member

    I've got a new Dell 2950 server with 16GB memory and a single quad core processor. It will connect to a MD 1000 Dell storage array. I've also got an open license for either 64 bit Windows Std 2003 or 2008 and I have an open license for either SQL 2005 or 2008. Should I go with the latest and greatest 2008 versions or should I go with 2003/2005? Also, I see that Windows has a "server core" version now. Should I go with that version since this box will be SQL only? Thanks!
  2. moh_hassan20 New Member

    64 bit is the new supported environment for Microsoft product servers. All bench tests are based on 64 bit.
    O.S: Windows 2008 64 bit
    SQL server 2008 64 bit.
    it is better to have dual quad core( if possible) to get high cpu performance.

  3. deepakontheweb New Member

    here are my personal preferences in order.. Rest up to you!OS: Windows 2003/2008 Enterprise Edition 64Bit - ( go for Ent edition)SQL: SQL Server 2008/2005 Standard Edition 64Bit - (1 Processor License)
  4. MohammedU New Member

    I will go with window 2008 standard edition + sql 2008 standard edition...
    EE is very expensive compare to SE...unless you want to use all the features and resources...
  5. deepakontheweb New Member

    Windows Server 2008 Standard Edition 32 bit can use maximum of 4 GB; That means 12Gb out of 16GB will not be used if 32 bit standard edition of windows is used; instead use a 64bit to go till 32GB support. FYI,... http://msdn.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2008

Share This Page