Link gốc: https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-2017
Theo dõi các thông tin sau để cập nhật dánh sách Phần cứng và Phần mềm tối thiểu để cài đặt và chạy SQL Server 2019 trên Window OS.
SQL Server 2017 (14.x) có bộ hỗ trợ SQL Server trên Linux. Xem chi tiết Hardware and Software Requirements for SQL Server on Linux.
This article applies to SQL Server 2016 (13.x) and later.
Try it out:
- Download SQL Server from the Evaluation Center.
- Spin up a Virtual Machine with SQL Server 2016 already installed.
The following considerations apply to all editions:
- We recommend that you run SQL Server on computers with the NTFS or ReFS file formats. Installing SQL Server 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 prerequisite. .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:
- SQL Server Native Client
- SQL Server Setup support files
- For minimum version requirements to install SQL Server on Windows Server 2012 or Windows 8, see Installing SQL Server on Windows Server 2012 or Windows 8(https://support.microsoft.com/kb/2681562).
The following requirements apply to all installations:
|.NET Framework||SQL Server 2016 (13.x) RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2016 (13.x) setup automatically installs .NET Framework. You can also manually install .NET Framework from Microsoft .NET Framework 4.6 (Web Installer) for Windows.
SQL Server 2019 preview requires .NET Framework 4.6.2. Available from Download Center
For more information, recommendations, and guidance about .NET Framework 4.6 see .NET Framework Deployment Guide for Developers.
Windows 8.1, and Windows Server 2012 R2 require KB2919355 before installing .NET Framework 4.6.
|Network Software||Supported operating systems for SQL Server 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: VIA protocol is not supported on failover clusters. Clients or applications running on the same node of the failover cluster as the SQL Server instance, can use Shared Memory protocol to connect to SQL Server using its local pipe address. However this type of connection is not cluster-aware and will fail after an instance failover. It is therefore not recommended and should only be used in very specific scenarios.
Important: The VIA protocol is deprecated. This feature is in maintenance mode and may 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.
For more information about Network Protocols and Network Libraries, see Network Protocols and Network Libraries.
|Hard Disk||SQL Server requires a minimum of 6 GB of available hard-disk space.
Disk space requirements will vary with the SQL Server components you install. For more information, see Hard Disk Space Requirements later in this article. For information on supported storage types for data files, see Storage Types for Data Files.
|Drive||A DVD drive, as appropriate, is required for installation from disc.|
|Monitor||SQL Server requires Super-VGA (800×600) or higher resolution monitor.|
|Internet||Internet functionality requires Internet access (fees may apply).|
The following memory and processor requirements apply to all editions of SQL Server:
Express Editions: 512 MB
All other editions: 1 GB
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|
Server Core Support:
SQL Server 2017 is now supported on a Server Core installation of Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, and Windows Server 2019.
Installing SQL Server 2017 on Server Core mode is supported by the following editions of Windows Server:
|Windows Server 2019 Standard||Windows Server 2019 Datacenter|
|Windows Server 2016 Standard||Windows Server 2016 Datacenter|
|Windows Server 2012 R2 Standard||Windows Server 2012 R2 Datacenter|
|Windows Server 2012 Standard||Windows Server 2012 Datacenter|
|Windows Server 2008 R2 SP1 Standard||Windows Server 2008 R2 SP1 Datacenter|
|Windows Server 2008 R2 SP1 Enterprise||Windows Server 2008 R2 SP1 Web|
During installation of SQL Server, 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.
Actual hard disk space requirements depend on your system configuration and the features that you decide to install. The following table provides disk space requirements for SQL Server components.
|Feature||Disk space requirement|
|Database Engine and data files, Replication, Full-Text Search, and Data Quality Services||1480 MB|
|Database Engine (as above) with R Services (In-Database)||2744 MB|
|Database Engine (as above) with PolyBase Query Service for External Data||4194 MB|
|Analysis Services and data files||698 MB|
|Reporting Services||967 MB|
|Microsoft R Server (Standalone)||280 MB|
|Reporting Services – SharePoint||1203 MB|
|Reporting Services Add-in for SharePoint Products||325 MB|
|Data Quality Client||121 MB|
|Client Tools Connectivity||328 MB|
|Integration Services||306 MB|
|Client Components (other than SQL Server Books Online components and Integration Services tools)||445 MB|
|Master Data Services||280 MB|
|SQL Server Books Online Components to view and manage help content*||27 MB|
|All Features||8030 MB|
*The disk space requirement for downloaded Books Online content is 200 MB.