Microsoft SQL Server 2016 Recommendation

The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the earlier MS SQL Server releases, SQL Server 2016 Express edition is also FREE and capable to support small to medium size applications. Following are the minimum hardware and software requirements to install and run SQL Server 2016.

Component
Requirements
Supported OS for SQL Server Express Edition
Windows Server 2012 R2 Datacenter, Windows Server 2012 R2 Standard, Windows Server 2012 R2 Essentials, Windows Server 2012 R2 Foundation, Windows Server 2012 Datacenter, Windows Server 2012 Standard, Windows Server 2012 Essentials, Windows Server 2012 Foundation, Windows 10 Home, Windows 10 Professional, Windows 10 Enterprise, Windows 8.1, Windows 8.1 Pro, Windows 8.1 Enterprise, Windows 8, Windows 8 Pro, Windows 8 Enterprise.
Supported OS for SQL Server Web Edition
Windows Server 2012 R2 Datacenter, Windows Server 2012 R2 Standard, Windows Server 2012 R2 Essentials, Windows Server 2012 R2 Foundation, Windows Server 2012 Datacenter, Windows Server 2012 Standard, Windows Server 2012 Essentials, Windows Server 2012 Foundation.
Supported OS for SQL Server Standard Edition Windows Server 2012 R2 Datacenter, Windows Server 2012 R2 Standard, Windows Server 2012 R2 Essentials, Windows Server 2012 R2 Foundation, Windows Server 2012 Datacenter, Windows Server 2012 Standard, Windows Server 2012 Essentials, Windows Server 2012 Foundation, Windows 10 Home, Windows 10 Professional, Windows 10 Enterprise, Windows 8.1, Windows 8.1 Pro, Windows 8.1 Enterprise, Windows 8, Windows 8 Pro, Windows 8 Enterprise.
Memory
Minimum
  • Express Edition: 512 MB
  • All other Editions: 1 GB
Recommended
  • Express Edition: 1 GB
  • All other Editions: At least 4 GB to ensure optimal performance.
Processor Type
X64 Processor
  • AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support. SQL Server 2016 does not support x86 processors.
Processor Speed
Minimum
  • x64 Processor: 1.4 GHz
Recommended
  • 2.0 GHz or faster
Hard Disk Space
  • SQL Server 2016 requires a minimum of 6 GB of available hard-disk space.
  • Disk space requirements may vary with the SQL Server 2016 components you install. Refer this for more information on disk space requirements of SQL Server 2016.
Hardware & Software Requirements
  • SQL Server 2016 RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2016 setup automatically installs .NET Framework. You can also manually install .NET Framework 4.6 manually.

  • Windows 8.1, and Windows Server 2012 R2 require update KB2919355 before installing .NET Framework 4.6.
File Formats
  • It is recommended to run SQL Server 2016 on computers with the NTFS or ReFS file formats. SQL Server 2016 can be installed on computer with FAT32 file system, but not recommended as it is less secure than the NTFS or ReFS file systems.

Setup on Remote Desktop
  • SQL Server 2016 setup will fail, when the setup is launched through Remote Desktop Connection with the media on a local resource in the RDC client. To install SQL Server 2016 on the remote server, the media must be on a network share or local to the physical or virtual machine. SQL Server installation media may be either on a network share, a mapped drive, a local drive, or presented as an ISO to a virtual machine.


Above are minimum requirements to run MS SQL Server 2016 with the basic components. Windows Operating System along with other software like IIS, WebsitePanel, DNS Server, FTP Server, MySQL and Mail Server will create additional overhead to Windows VPS. To prevent your VPS running out of memory, we recommend following VPS configurations.


Windows Server 2012 R2 with MS SQL Server 2016

  • vCPU: 3 vCPU
  • RAM: 3 GB or Higher
  • Disk space: Minimum 45 GB


Recommended VPS Plans




  • 47 Users Found This Useful

Was this answer helpful?

Related Articles

How to Fix Error "Could not allocate space for object 'X' in database"?

Error Message Could not allocate space for object 'dbo.ABC_XYZ_XYZ'.'AB__ABC_XYZ__XYZ' in...

Microsoft SQL Server 2012 Recommendation

Microsoft SQL Server 2012 Express is a feature-rich yet FREE data management system. It is far...

How to restore MSSQL database from SQL Server Management Studio?

This article will guide you on how to restore MSSQL database from SQL Server Management Studio....

How to fix "Upgrade Error - Valid Database compatibility level and successful connection rule"?

One of our Windows VPS customers wanted to upgrade SQL Server from SQL Server 2008 R2 to SQL...

Microsoft SQL Server 2014 Recommendation

The SQL Server 2014 Express is yet another feature-rich data management system from Microsoft....