Microsoft SQL Server 2012 Recommendation

Microsoft SQL Server 2012 Express is a feature-rich yet FREE data management system. It is far more powerful and reliable than its predecessor Microsoft SQL Server 2008 Express. It delivers a Rich and Reliable data store for lightweight Web Sites and desktop applications.

Following are the minimum hardware and software requirements to install and run SQL Server 2012.

Component
Requirements
Supported OS
Windows 7, Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2
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
Processor
  • AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support.

x86 Processor
  • Pentium III-compatible processor or faster.
Processor Speed
Minimum
  • x86 Processor: 1.0 GHz
  • x64 Processor: 1.4 GHz
Hard Disk Space
  • SQL Server 2012 requires a minimum of 8 GB of available hard-disk space.
  • Disk space requirements may vary with the SQL Server 2012 components you install.


These are the minimum requirements to run MS SQL Server 2012 with basic components. Windows Operating system along with other software like IIS, WebsitePanel, MySQL and Mail Server will create additional overhead to VPS. In order to prevent your VPS run out of memory, we recommend following VPS configurations.

Windows Server 2008 with MS SQL Server 2012


  • vCPU: 2 vCPU
  • RAM: 2 GB or Higher
  • Disk space: Minimum 35 GB


Recommended VPS Plans



Windows Server 2012 with MS SQL Server 2012

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


Recommended VPS Plans




  • 148 Users Found This Useful

Was this answer helpful?

Related Articles

How to Shrink Transaction Logs of Database in MS SQL?

This article will assist you to shrink/truncate the transaction logs of database in MS SQL...

How to use MSSQL Activity Monitor to find the most expensive query?

A slow and long running SQL query execution consumes much processor, memory, and disk of your...

How to Restore SQL Server 2012 Database Backup to SQL Server 2008?

Ideally, there is no way you can restore MS SQL Server 2012 database to SQL Server 2008 even if...

Microsoft SQL Server 2016 Recommendation

The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the...

How to fix an error "change password failed for login sa"?

Sometimes you receive following error while trying to reset MS SQL sa password via SQL Management...