Veeam – Upgrade to SQL Express 2016 SP1 for improved performance 1


Upgrade SQL Express for improved performance with Veeam

One of the take away for me from VeeamON was that upgrading the version of SQL backing Veeam to either 2014 or 2016 will yield great improvements in performance. Now even the latest version of Veeam 9.5 only ships with SQL 2012 Express. Issues cited by Veeam with deploying newer versions of SQL express at install time of backup and replication are the reason why it does not ship with it. So lets take a look at some of the enhancements and reasons why you should upgrade. These features are available in Express edition.

In memory OLTP (Online Transaction Processing)

I’m not going to lie, I am no SQL expert. However moving anything from disk to in memory is going to improve its speed. OLTP is moved to in memory starting with SQL server 2014. You can read more about this feature here

Advanced Security – Always encrypted data

Encrypted data, gotta be a good thing right? Now from what I can gather this wont be enabled out the box but essentially it allows for a demarcation of data access between application owners and database owners. Read more here

You can find a full breakdown of features here

The upgrade process

Run up services.msc and take a look at what version of SQL you are currently running

SQL01

Search the interwebs for SQL Express 2016 download and grab a copy of it. It downloads as an update launcher which will download the required binaries as you step through the installation wizard.

Choose Custom install

SQL02

Choose media location to download the product binaries

SQL03

Make a cup of covfefe whilst you wait for the download to complete

SQL04

NOTE – Before starting the upgrade, Disable all Veeam jobs from the Veeam console and stop all Veeam services. Make sure you have a backup of the database. You have been warned!

SQL12

Launch the upgrade wizard

SQL05

Accept the EULA

SQL06

Check for updates during install

SQL07

Choose the instance of SQL you would like to upgrade, this is the instance we took at look at the beginning of this process. Note that version 11 = SQL 2012

SQL08

Grab more covfefe

SQL09

And done, reboot the server

SQL10

Take a look at the SQL server version following the reboot. V13 is SQL 2016. Remember it was V11 prior to upgrade

SQL11

Remember to enable the Veeam services at this point.

And that’s it, easy as pie, piece of cake, jobs a goodun.

Ian


Leave a comment

Your email address will not be published. Required fields are marked *

One thought on “Veeam – Upgrade to SQL Express 2016 SP1 for improved performance