|
Currently running SQL Server 2008 Enterprise Edition on Windows Server 2003 Enterprise Edition. What are the pros and cons of upgrading to Windows Server 2008?
(comments are locked)
|
|
Microsoft gives a marketing list of reasons here - http://www.microsoft.com/windowsserver2008/en/us/why-upgrade.aspx The unlisted reason I really like, because most shops seem to overlook it, is that Disk Partition Alignment is finally fixed by default - http://msdn.microsoft.com/en-us/library/dd758814(v=sql.100).aspx You won't get this benefit if you simply re-attach your unaligned W2K3 disks, you need to go with freshly formatted disks. It also won't help if you have already manually aligned your W2K3 disk partitions. +1 for the partition alignment mention. Saves a lot of hassle but not sure how that works on an in-place upgrade. If you fix the issue on 2003 after commissioning the server then you have to (re)format the drive. An in-place upgrade wont format the disk so I wonder if it would fix the alignment issue.. .. ..
Aug 01 '11 at 08:56 AM
Fatherjack ♦♦
W2K8 must format the disks to fix the partition alignment. If you re-use your existing partitions, and haven't corrected the alignment, the misalignment will carry over.
Aug 01 '11 at 09:04 AM
KenJ
(comments are locked)
|
|
Apparently if you are using replication you can see some improvement running it on Server 2008, see here. You will never see any cons for running the current operating system with Microsoft :).
(comments are locked)
|
|
For me I have seen much better usage of memory with Windows Server 2008 over Server 2003. Depending on your hardware specs you might be able to get around having to have Ent Ed of Windows. The disk partition alignment @KenJ mentioned is huge for SQL Server. I was very excited to hear that was taken care of in Server 2008. Running on an Operating System that is current is a plus by itself.
(comments are locked)
|
|
Could I suggest that if you take the step, go for 2008 R2. There aren't many differences, but stuff like Powershell have been improved upon and the clustering too, if that were to come up in the future. The network improvements that @meltondba talks about really do work!
(comments are locked)
|
won 2008 Ent Edition too ?