Microsoft SQL Server 2012 Comparison

Ever since 2005, SQL Server has evolved as technology and business data needs have grown more complex, innovating fast, dynamic new ways of helping you gather, visualize, analyze, and manage your company's data.

The latest version, SQL Server 2012, provides a new standard for mission critical databases and end-to-end BI capabilities to help businesses like yours achieve the greatest success in their data operations.

Choose the Right Edition for Your Business

PEER 1 Hosting offers three SQL Server 2012 editions to give you the most flexibility when building your solution.

Start a live chat for help understanding which SQL Server 2012 edition is right for your business.

 

SQL Server 2012 Capabilities
SQL Server 2012 Editions for PEER 1 Hosting
Web1
Standard
Enterprise
Hosting Scenarios & Target Customers
Web Apps, Dedicated
Departmental LOB, Small/Mid-Scale, Dedicated
Mission Critical, Large Scale, Dedicated or Shared
Maximum Number of Cores
4 Sockets or 16 Cores
4 Sockets or 16 cores
OS Max2
Basic OLTP, Programmability & Developer Tools, Manageability (Management studio, policy based management)
Basic Corporate BI (Reporting, Analytics, Multidimensional Semantic Model, Data Mining)

Partial Support
Self-Service Business Intelligence (Alerting, Power View, PowerPivot for SharePoint Server)3
Advanced Corporate BI (Tabular BI Semantic Model, Advanced Analytics and Reporting, VertiPag™ In-Memory Engine)
Advanced Security (Advanced auditing, transparent data encryption)
Data Warehousing (Column store index, compression, partitioning)

 

  • 1 Web Edition will only be available via SPLA.
  • 2 Existing SQL Server Enterprise edition licenses in the Server + CAL licensing model upgraded to SQL Server 2012 will be limited to server deployments with 20 cores or less. Refer to Datasheet for more details.
  • 3 SharePoint Server with Enterprise CAL is a system requirement for Power View and PowerPivot for SharePoint. Alerting is accessible through SharePoint Foundation or above.