Which edition os SQL sever 2005 or 2008

  • Hi All,

    We are planning to change our server systems on which we have been running so far SQL server 2005 Standard and Enterprise editions.

    Now we are planning to buy a server with 2 physical processors, each with QUAD-Core. We are also expecting up to 64 MB of memory limit.

    My question is which edition of SQL server 2005 or 2008 should we consider?

    Especially, I would be very much interested in whether or not DUAL-CORE or QUAD-CORE choice affects which edition of SQL Sever 2005 or 2008 we should be buying.

    Many thanks indeed for your hints.

    Niyala

  • I'm not aware of any relationship between dual/quad-core and the SQL Edition you should choose. Both work fine on dual and quad-core systems and both support all (logical) CPU's as long as the the OS does.

    What's more important is first of all do you plan to use Windows 2003 or 2008, 32-bit or 64-bit.

    Do you need any features only availbale in the Enterpise version ?

    With 64Gb of RAM I strongly suggest using 64-bit. If you do so be careful when choosing standard edition, because you cannot lock pages in memory. In that case under memory pressure it can happen that SQL Server pages out all it's memory.

    This KB-article has some other tips, but in my experience none of them really is a solution.

    [font="Verdana"]Markus Bohse[/font]

  • Any specific feature you plan to use in SQL 2008. If your application is running fine on SQL Server 2005 and you are'nt going to use SQL 2008 feature(s) then i would suggest you stick to SQL 2005. I like to wait for some time and let SQL 2008 stabilise before moving on to it.

    "Keep Trying"

  • Thanks for your information. However, I was still wondering whether or not MS SQL Server 2005 enterprise or standard eddition was tested under Windows Server 2008, 64-bit. In other words, are MS SQL Server 2005 editions supported by Windows Server 2008?

    Would you be able to give a hint on this please?

    Regards

    Niyala

  • I would think Microsoft would certify Microsoft SQL Server 2005 on Windows 2008

    but I recalled reading that SQL 2008 actually perform betters on Windows 2008 (not surprisingly)

    White Paper: Running SQL Server 2008 on Windows Server 2008

    http://www.microsoft.com/sqlserver/2008/en/us/wp-run-sql-2008-on-windows-server-2008.aspx

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • Two versions tend to be tested/supported on the OS. So I'd expect SS2K5 and SS2k8 were tested on W2K8.

    I'd actually look at 2008 as a more stable version of 2005. The core engines haven't changed a lot and not that there aren't bugs, but I think it's more stable and a better choice for your server. If it runs on 2005, it should work fine on 2008 and I wouldn't give up 3 years of support these days for no reason.

  • Thanks indeed.

    In fact our organisation has several branches or so to say regional offices. At each regional office, we have been running MSDE or MS SQL Server 2005 express edition. We have a central Management Point where we have a standard or Enterprise edition of SQL Server 2005. Using the central management point, we manage data and monitor applications at the regional offices. On all of our servers and clients, we have windows 2003 servers.

    NOW, we are planning to change our infrastructure.

    1. We want to install Windows server 2008

    2. We want to install MS SQL Server 2008 to do our database tasks.

    However, we are not sure yet whether MS SQL server 2008 is stable and which edition we should choose.

    Therefore, my question is to make sure that we chose the right edition on the right platform. That is:

    SQL Server 2005 on Windows Server 2008?

    SQL Server 2008 on Windows Server 2008?

    We are planning at least two processors each with QUAD-Core. And which editions works well on these processors?

    I appreciate any advice and hints.

    Regards

    Niyala

  • 2008 is stable, but you have to decide that.

    Either one works, there's no compelling reason to say 2005 or 2008 unless you need some specific feature in 2008.

  • My vote is SQL 2008 on Windows 2008

    License costs probably around the same, but you get more from SQL2008 (not necessarily always faster though, judging from Brent's upgrade story[/url] at Stackflow)

    SQL Server 2008 comparison

    http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx

    Standard supports 4 CPU's (I am not sure if it's physical CPU or cpu-core's)

    Enterprise supports to OS Max

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply