The topic lists the minimum hardware and software
requirements to install and run SQL Server 2016
Source from below site:
·
Download SQL Server from the
·
Spin up a Virtual Machine with already installed.
The following
considerations apply to all editions:
·
We recommend that you run SQL Server 2016 on computers with the
NTFS or ReFS file formats. Installing SQL Server 2016 on a computer with FAT32
file system is supported but not recommended as it is less secure than the NTFS
or ReFS file systems.
·
SQL Server Setup will block installations on read-only, mapped,
or compressed drives.
·
Installation fails if you launch setup through Remote Desktop
Connection with the media on a local resource in the RDC client. To install
remotely 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.
·
SQL Server Management Studio installation requires installing
.NET 4.6.1 as a pre-requisite. .NET 4.6.1 will be automatically installed by
setup when SQL Server Management Studio is selected.
·
SQL Server Setup installs the following software components
required by the product:
o SQL Server Native
Client
o SQL Server Setup
support files
·
For minimum version requirements to install SQL Server on
Windows Server 2012 or Windows 8,
This topic contains the following
sections:
·
·
·
·
·
·
Hardware and Software Requirements
The following requirements apply to all installations:
|
Component
|
Requirement
|
|
.NET Framework
|
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 from Microsoft .NET Framework 4.6 (Web
Installer) for Windows.
Note: Windows 8.1, and Windows Server 2012
R2 require KB2919355 before installing .NET Framework 4.6.
|
|
Network Software
|
Supported operating systems for SQL Server
2016 have built-in network software. Named and default instances of a
stand-alone installation support the following network protocols: Shared
memory, Named Pipes, TCP/IP and VIA.
Note: Shared memory and VIA are not supported
on failover clusters.
Also note that the VIA protocol is deprecated.
This feature will be removed in a future version of Microsoft SQL Server.
Avoid using this feature in new development work, and plan to modify
applications that currently use this feature.
|
|
Hard Disk
|
SQL Server 2016 requires a minimum of 6 GB of
available hard-disk space. Disk space requirements will vary with the SQL
Server 2016 components you install.
|
|
Drive
|
A DVD drive, as appropriate, is required for
installation from disc\use virutal clone drive to install
|
|
Monitor
|
SQL Server 2016 requires Super-VGA (800x600) or
higher resolution monitor.
|
|
Internet
|
Internet functionality requires Internet access
(fees may apply).
|
|
Processor, Memory,
and Operating System Requirements
|
|
The following memory and processor
requirements apply to all editions of SQL Server 2016:
|
|
Component
|
Requirement
|
|
Memory
|
Minimum:
|
|
Express Editions: 512 MB
|
|
|
All other editions: 1 GB
|
|
|
Recommended:
|
|
|
Express Editions: 1 GB
|
|
|
All other editions: At least 4 GB and should
be increased as database size increases to ensure optimal performance.
|
|
|
Processor Speed
|
Minimum: x64
Processor: 1.4 GHz
|
|
Recommended: 2.0
GHz or faster
|
|
|
Processor Type
|
x64 Processor: AMD Opteron, AMD Athlon 64, Intel
Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
|
|
Note: Installation of SQL Server 2016 is supported
on x64 processors only. It is no longer supported on x86 processors.
|
|
|
WOW64 Support:
|
WOW64 (Windows 32-bit on
Windows 64-bit) is a feature of 64-bit editions of Windows that enables
32-bit applications to run natively in 32-bit mode. Applications function in
32-bit mode, even though the underlying operating system is a 64-bit
operating system. WOW64 is not supported for SQL Server 2016 installations.
However, Management Tools are supported
in WOW64.
|
|
Operating System Support:
|
The SQL Server 2016 editions
are classified into the following:
|
|
Principal Editions of SQL Server 2016
|
|
|
Breadth Editions of SQL Server 2016
|
|
|
Reporting Services -
SharePoint
|
|
|
Reporting Services Add-in for SharePoint
products
|
Principal
Editions of SQL Server 2016
The following table shows the operating system
requirements for the principal editions of SQL Server 2016:
|
SQL Server Edition
|
Supported Operating System
|
|
SQL Server
Enterprise
|
Windows Server 2016
Datacenter
Windows Server 2016 Standard 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 |
|
SQL Server Standard
|
Windows Server 2016
Datacenter
Windows Server 2016 Standard 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 |
|
SQL Server Web
|
Windows Server 2016
Datacenter
Windows Server 2016 Standard 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 |
Breadth Editions of SQL Server 2016
The following table
shows the operating system requirements for the breadth editions of SQL Server
2016:
|
SQL Server Edition
|
Supported Operating System
|
|
SQL Server Developer
|
Windows Server 2016
Datacenter
Windows Server 2016 Standard 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 |
|
SQL Server Express
|
Windows Server 2016
Datacenter
Windows Server 2016 Standard 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 |
Hard Disk Space Requirements
During installation
of SQL Server 2016, Windows Installer creates temporary files on the system
drive. Before you run Setup to install or upgrade SQL Server, verify that you
have at least 6.0 GB of available disk space on the system drive for these
files. This requirement applies even if you install SQL Server components to a
non-default drive.
The
supported storage types for data files are:
·
Local Disk
·
Shared Storage
·
·
SMB File Share
No comments:
Post a Comment