Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 

Free/Standard Edition

Professional Edition

Enterprise Edition

Platform

64-bit

64-bit

64-bit

Operating System

Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched)

Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched)

Dedicated Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched)

 

Application Memory*

Minimum - 4 GB

Recommended - 8 GB

Minimum - 8 GB

Recommended - 16 GB

Minimum** - 16 GB

Recommended - 32 GB

Processors*

4 Cores

Minimum - 4 Cores

Recommended - 8 Cores

Minimum** - 8 Cores

Recommended - 16 Cores

SQL Server Edition

Microsoft SQL Server 2008/2008 R2/2012/2014/2016 Standard Edition (fully patched)

Microsoft SQL Server 2008/2008 R2/2012/2014/2016 Standard Edition (fully patched)

Microsoft SQL Server 2008/2008 R2/2012/2014/2016 Standard or Enterprise Edition (fully patched)

SQL Instance Memory

4 GB

Minimum - 8 GB

Recommended - 16 GB

Minimum** - 16 GB

Recommended - 32 GB

SQL Server Processors

4 Cores

8 Cores

Minimum** - 8 Cores

Recommended - 16 Cores

SQL Server Storage:

 

 

 

SQL System Disk (Mirrored)

10 GB

10 GB

10 GB

SQL Page File Disk10 GB10 GB10 GB
SQL Database Disk20 GB per year60 GB per year
A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs
Maximum 600 GB per year
A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs
SQL Transaction Log Disk

1 GB

5 GB
A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs
50 GB
A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs
SQL Temp Database Disk20% of Database Disk size20% of Database Disk size
Recommended - A separate physical hard disk, preferably solid-state drive (SSD)
20% of Database Disk size
Recommended - A separate physical hard disk, preferably solid-state drive (SSD)
SQL Temp Database Log Disk1 GB5 GB5 GB
SQL RAIDRAID 10 or similarRAID 10 or similarRAID 10 or similar

Additional Software & Services

  • Microsoft .NET Framework 3.5
  • Microsoft .NET Framework 4.6.2
  • Microsoft SQL Server Data-Tier Application Framework (x64)
  • IIS 7.0, 7.5, 8.0 or 8.5
  • Additional Web Server (IIS) Role Services
  • Google Chrome, Mozilla Firefox, Microsoft Internet Explorer 9.0 or higher
  • Microsoft .NET Framework 3.5
  • Microsoft .NET Framework 4.6.2
  • Microsoft SQL Server Data-Tier Application Framework (x64)
  • IIS 7.0, 7.5, 8.0 or 8.5
  • Additional Web Server (IIS) Role Services
  • Google Chrome, Mozilla Firefox, Microsoft Internet Explorer 9.0 or higher
  • Microsoft .NET Framework 3.5
  • Microsoft .NET Framework 4.6.2
  • Microsoft SQL Server Data-Tier Application Framework (x64)
  • IIS 7.0, 7.5, 8.0 or 8.5
  • Additional Web Server (IIS) Role Services
  • Google Chrome, Mozilla Firefox, Microsoft Internet Explorer 9.0 or higher

...