Pre-Requisites for Different Version of Microsoft SQL Server on Single Page

This article will give you a complete idea on the prerequisites to install Microsoft SQL Server. 

This will cover different versions of SQL Server starting from 2012 to 2022. 

It will give you knowledge of the minimum hardware & software requirements to install MS SQL Server.

The hardware requirement is given below for all major SQL Server versions:

Hardware Requirements

 

Hard Disk

Min. Memory
Express Edition

Min. Memory
All Other Editions

SQL Server 2012

Around 4 GB

512 MB

1 GB

SQL Ser. 2012 R2

Around 4 GB

512 MB

1 GB

SQL Server 2014

Around 4 GB

512 MB

1 GB

SQL Server 2016

Around 6 GB

512 MB

1 GB

SQL Server 2017

Around 6 GB

512 MB

1 GB

SQL Server 2019

Around 6 GB

512 MB

1 GB

SQL Server 2022

Around 6 GB

512 MB

1 GB

Hardware Requirement Table-1

Hardware Requirements

 

Memory Recommended
Express Edition

Memory Recommended
All Other Editions

SQL Server 2012

1 GB

At least 4 GB

SQL Ser. 2012 R2

1 GB

At least 4 GB

SQL Server 2014

1 GB

At least 4 GB

SQL Server 2016

1 GB

At least 4 GB

SQL Server 2017

1 GB

At least 4 GB

SQL Server 2019

1 GB

At least 4 GB

SQL Server 2022

1 GB

At least 4 GB

Hardware Requirement Table-2

Hardware Requirements

 

Minimum - Processor Speed

Recommended - Processor Speed

SQL Server 2012

1 GHz-32 bit & 1.4 GHz-64 bit

2.0 GHz

SQL Ser. 2012 R2

1 GHz-32 bit & 1.4 GHz-64 bit

2.0 GHz

SQL Server 2014

1 GHz-32 bit & 1.4 GHz-64 bit

2.0 GHz

SQL Server 2016

1.4 GHz-64 bit

2.0 GHz or Faster

SQL Server 2017

1.4 GHz-64 bit

2.0 GHz or Faster

SQL Server 2019

1.4 GHz-64 bit

2.0 GHz or Faster

SQL Server 2022

1.4 GHz-64 bit

2.0 GHz or Faster

Hardware Requirement Table-3

Software requirement is given below for all major SQL Server versions: