Comments on: SQL Server versions – Should you upgrade to the next release?https://www.pythian.com/blog/sql-server-versions-should-you-upgrade-to-the-next-release/
Love Your DataMon, 14 Aug 2017 19:01:13 +0000hourly1https://wordpress.org/?v=4.7.5By: Mohammed Mawlahttps://www.pythian.com/blog/sql-server-versions-should-you-upgrade-to-the-next-release/#comment-2033264
Tue, 04 Feb 2014 21:13:15 +0000http://www.pythian.com/blog/?p=63870#comment-2033264I agree that upgrading involves cost that has to be considered , not only licensing but also the costs to align environment on Hardware & Applications.

However , I think it’s down to the needs of your business.If your growth necessitates upgrade then you have to find a way.Growth will necessitate better hardware anyway so sometimes Hardware will have to be acquired or because it has been on for years and you don’t want things to suddenly fail.

– Getting support for older versions can be prohibitive sometimes. Support ends after some years and no patches are released. newer versions enjoy longer span of support (including hotfixes , service pack ..etc)

– Newer versions tend to provide features that save resources: like backup compression , data compression , DB mirroring stream log compression. Before these features , you either had to pay for 3rd party tools or stretch your resources. Resource governor helps cap runaway queries.

Many clients still have SQL 2000 & 2005 because simply they host small databases with minimal features used and things has been running well for years. With visualization , things are even getting better for such kind of instances.

So my point again, if you have to then you need to bite the bullet , it’ll pay back later.