What to change to take advantage of SQL Server 2016 upgrade RRS feed

  • Question

  • We are migrating from SQL Server 2008 R2 Enterprise Edition  on Windows Server 2008 R2 to SQL Server  2016 Enterprise Edition on Windows Server 2106. We are also upgrading our hardware from a basic 50 gb, 3.4 GHz 2 core to  150 gb, 3.6 GHz 8 core.

    We use the RDBMS for data warehousing, meaning we run SSIS to import data from various files, and other databases. Then we transform the imported data into dimensional data model (facts and dimensions) and run reports. We also run Index Optimization Procs, Database Integrity Checks and Database Backups as maintenance tasks.

    What should we do on our ETLs, database objects, maintenance tasks to take advantage of SQL 2016. One thing I know is to start using column store indexes for improved performance.

    Thanks in advance.

    Monday, May 6, 2019 2:08 PM

All replies