Home Forums SQL Server 2012 SQL 2012 - General Choose: SQL 2012 Enterprise or SQL 2016 Standard RE: Choose: SQL 2012 Enterprise or SQL 2016 Standard

  • December 25, 2017 at 8:58 am

    #1973385

    ReReplaced - Friday, December 22, 2017 7:35 PM

    That's the choice I've been given. 1 month into work at a small business with 1 well used 2008 r2 SQL Server (average 9k transactions/sec. with sustained periods of 20K mainly due to BizTalk EDI. 3 db's around 100 GB, 12 smaller ones, Hyper V environment not efficiently configured (1 lun to rule them all)

    Which would you choose? What other questions would you ask before deciding? (we use SQL server very generically).

    I think it'll be based on your requirement, some of the features of SQL 2016 are,
    1) In memory tables
    2) Update able column store indexes
    3) High number of Always ON secondaries
    4) High size of buffer
    5) Temporal tables support ( alternative for SCD) and many more...

    If your project requirements are not requiring / considering the above factors, then you can proceed with SQL 2012 enterprise edition. Please wait for others suggestion as well...