SQL Server 2016 System Requirements

  Use code KB4KDO0L9 to receive a 10% recurring discount on any server.

Microsoft recently updated the language used by database servers. Microsoft SQL, also known as MS SQL 2016, is a powerful and popular Relational Database Management System (RDBMS).

MS SQL 2016 is Microsoft's move towards "cloud first, mobile first technology." It's optimized for lightning-fast data searches and analytics. All of which can require heavy lifting from your system.

But what are the system requirements for running MS SQL 2016? We've put together a small guide to help you figure out if you can install Microsoft's SQL server 2016.

See Also: SQL Server 2016 Hosting: What You Need to Know

SQL Server 2016 Requirements

The system requirements for SQL Server 2016 for the best performance are:

  • 6GB of Disk Space in the NTFS file format
  • .NET Framework 4.6 or later
  • 1GB of Memory
  • 2.0 GHz or faster 64 bit processor
  • A Compatible Windows Server OS

Let's discuss each requirement in more detail:

Hard Drive Requirements

MS SQL 2016 requires a minimum of 6 GB of available hard drive space. Different configurations of the server software will have different hard drive requirements. Make sure to check how much hard drive space the version of MS SQL you're installing requires. We always recommend a Solid State Disk be used if possible on a database server to ensure peak database performance. Using the NTFS drive format is also recommended by Microsoft.

.NET Framework

You'll need to have .NET Framework 4.6 or later installed to be able to run MS SQL 2016. The SQL server software will usually prompt you to install the framework if you haven't already. You can also download the Framework installer if you haven't already.

Windows 8.1 or later and Windows Server 2012 R2 are also necessary for running .NET Framework 4.6 or later.

Memory Requirements

The absolute minimum amount of RAM is 512MB for the Express version of SQL Server 2016. To adequately meet the needs of all other editions for SQL server hosting, 1GB of more RAM is recommended. Most production servers will have at least 4GB of RAM available, and that would be an optimal amount to have in case the server has any bursts of activity. 

Processor

x86 processors are no longer supported by SQL Server 2016, therefore the SQL Server requirements call for a 64 bit processor. While the server can run on a minimum of a 1.4 GHz processor, 2.0GHz or faster is the recommended speed for best performance.

Compatible Operating Systems

In order to setup SQL Server hosting, you'll need a compatible Operating System. SQL Server is supported on Windows Server 2012 Standard / Datacenter editions as well as Windows Server 2016 Standard / Datacenter. 

Network Software

OS supported by MS SQL 2016 feature dedicated network software. Installing an MS SQL 2016 server supports TCP/IP, named pipes, shared memory, and VIA transfer protocols.

How Much Does SQL Server 2016 Licensing Cost?

There are 4 versions of Microsoft SQL Server 2016. The Express and Developer editions are both extremely limited but are available as a free download. The Standard edition is $3,717 per CPU core and the Enterprise edition is $14,256 per CPU core.

SQL Server Setup Recommendations

If you're planning on hosting your own SQL server there are a few other things you'll need to keep in mind.

Each database will need to be running the same version of SQL Server. The SQL Server collation setting must be configured correctly for each database, as well.

Full-text search is mandatory for both the operational database as well as the warehouse server.

Only use Windows Authentication for the computer hosting the operational database. Do not use Mixed Mode Authentication, which is a mixture of Windows Authentication and SQL Server Authentication. Mixed Mode Authentication is optional for the operational database but all contact is done via Windows. You'll have to stick with the Windows Authentication.

Deploy Your Next SQL Server 2016 Server

If you have any questions about database hosting or want to discuss your unique requirements, consider booking an expert server consultation. We'll review your business goals and help you select a server that will meet your database hosting needs.