Skip to main content
Question

SQL 2016: worth the upgrade?

  • October 28, 2016
  • 4 replies
  • 1 view
S
Forum|alt.badge.img

Hello fellow TimeXtender users,

We were wondering: is it worth upgrading from SQL 2014 to 2016 in the scenario where we use TX traditionally: stage - dw - cubes.

Has anyone done it and have you seen performance improvements?

Thanks!

Wim

CALM - Co

    4 replies

    J
    • JTreadwell
    • Community Manager
    • November 1, 2016

    I personally have not seen any difference using TX DWA with 2014 vs 2016. Anyone else?

    A
    Forum|alt.badge.img
    • andri
    • Known Participant
    • November 3, 2016

    I've not seen any difference in the typical scenarios we've upgraded for. One reason to upgrade is to be able to use Power BI on the cubes.

    If you're running Enterprise edition you could benefit from better column store indexes on fact tables.

    S
    Forum|alt.badge.img
    • support
    • Author
    • Known Participant
    • November 15, 2016

    Thanks for the feedback everybody.

    From Justin's feedback I gather that in theory cleansing rules should run faster. We are going to do some tests on our most complex ETLs and see if we see any performance difference.

    T
    • teld
    • New Participant
    • November 17, 2016

    I would say that with yesterday's announcement that SQL2016 SP moves support for compression, partitioning, columnstore from Enterprise Edition to Standard Edition, that would be a big reason for current 2014 Standard Edition upgrades to 2016:

    https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/sql-server-2016-service-pack-1-generally-available/

    Terms & ConditionsCookie settingsAccessibility statement