August 1, 2011 at 8:42 am
Can anyone out there provide me information or white papers regarding the benefits or disadvantages of upgrading a server (where SQL 2008 resides) from Windows Server 2003 to Windows Server 2008?
August 8, 2011 at 1:51 am
Dear Bob;
i need the same answer,and i have searched for a similar question and i think you might find the closest answer here :
read it.
Moustafa Chouraiki
System Administration Departement.
August 8, 2011 at 4:16 am
well windows 2003 will go out of support very soon
Make sure you choose 2008 R2, windows 2008 is old technology now.
windows 2008 R2 has a bunch of features that w2k3 doesn't.
windows 2008 R2 is allegedly faster.
Personally I highly rate windows 2008 R2, it really is very good, although if you're not familair with windows 7 you may find the interface irritating!
I would advise to do a new build and never upgrade in place however.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
August 8, 2011 at 8:02 am
On hindsight I guess I could provide a little more information.
I currently manage several SQL Server 2008 instances; and all of them are running on servers with Windows Server 2003.
I'd like to make a case for my superiors to upgrade to Windows Server 2008 (or perhaps 2008 R2 after reading the posts above).
So; what I'm looking for is justification for the upgrade by illustrating the benefits from a SQL Server stand point.
August 9, 2011 at 4:18 am
If you are on W2003 you are probably also on old hardware that is nearing the end of its useful life. As part of a platform refresh you are going to need to do, you should plan to go to W2008 R2.
W2008 R2 can take advantage of some hardware features that did not exist when W2003 came out. Second Level Address Translation (SLAT) is used by both W2008 R2 and SQL 2008 R2 to speed up processing. If your site wants to use RemoteFX for client machines, then SLAT hardware and W2008 R2 are pre-requisites. Expect other new things from Microsoft to need SLAT as time goes by. AFAIK Windows 8 will have SLAT as a pre-req.
Modern hardware tends to be cheaper to run than the old stuff. We get our kit from HP, and a 2-processor blade with 12 cores and 48GB memory now costs under GBP £5k. This type of power would have been maybe 50K only 5 years ago. Many sites find that moving to the latest 2 or 4 socket hardware can allow enough virtualisation to pay for the move in reduced software licensing costs, data centre space, and environmental costs.
My advice is to talk to your favourite hardware vendor and get them to help you put together a business case for an upgrade that will give you faster servers and cost less than your current setup.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 9, 2011 at 7:38 am
Thanks, EdVassie. We are planning our server hardware upgrade next fiscal year; so we'll probably do both at the same time. We recently made a mandatory switch to EMC SAN storage; so I'll contact them. Much appreciated. ~bob mcc
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply