April 21, 2022 at 9:56 am
Hey Everyone, My project wants to upgrade their sql server 2014 SP3 to newest one. I am not sure if I should pick sql server 2017 or just go with the latest 2019 version https://showbox.tools/. The databases we use is not very bulky and we have 12 databases in the production environment. Shall I just upgrade to 2017 now and wait to see how 2019 goes in future ? Thanks
April 21, 2022 at 10:59 am
If it was me, I’d be looking at 2019 or even 2022 depending on what the timeline is for its release and your timeline for upgrade.
2019 has been around for over 2 years now and is embedded quite well so don’t fear it.
I’d only consider 2017 if someone gave a very good compelling reason.
2017 drops into extended support in July so any bugs won’t get fixed unless it’s a CVE so to keep up with all fixes which is pretty important to have, I would advocate for 2019 or wait if you can for 2022.
April 21, 2022 at 11:52 am
My recommendation would be SQL Server 2019 at this point. It is at CU16 at present and this is important. For more than 8 years it has been my practice to get past the first few CU's of a release before taking that release to production.
To be extra cautious I would recommend when moving to SQL Server 2019 keep the Compatibility Level to 2014 and test. Then to diligence move to 2019 and test again. Then compare your benchmarks. This really has to do with the differences in the Cost Based Optimizer that produces your execution plans.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply