October 29, 2008 at 1:59 am
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
October 29, 2008 at 3:55 am
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]
October 29, 2008 at 4:32 am
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"
October 29, 2008 at 5:52 am
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
October 29, 2008 at 7:44 am
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
October 29, 2008 at 9:46 am
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 30, 2008 at 4:36 am
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
October 30, 2008 at 7:59 am
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 30, 2008 at 8:19 am
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
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply