14 Nov 2011

SQL Server 2012 is due to be released in the first quarter of 2012.  It will feature three main editions. 

NOTE:  Bookmark this thread, as we will update it to include future information as it becomes available.

The three main editions

Enterprise, BI (Business Intelligence) and Standard.  In addition there will still be Web Developer and Express versions of SQL Server 2012.

Microsoft will be eliminating Datacenter (features now part of Enterprise), Workgroup (Standard replaces it) and Standard for Small Business (Standard replaces it).

(click to enlarge)

 There are three licensing options:

  • Core-based Licensing for Enterprise
  • Server+ CAL (Client Access Licensing) licensing for Business Intelligence.
  • Choice of core-based licensing or Server+CAL licensing for Standard

The pricing is outlined as follows:

Enterprise sits at the top, includes all Standard and BI features, plus the "AlwaysOn" high availability, ColumnStore datawarehousing functionality and "Maximum Virtualization" (for users with Software Assurance licenses).  Enterprise has a 20-core max (256 logical processors).  You can only purchase CPU core licenses.

BI will have all of Standard's features plus Power View ("Crescent"), reporting and analytics, Power Pivot for SharePoint Services, data-quality services and master-data services.  16-core max.  There is not a CPU core license available.

Standard will offer basic database and reporting and analytics capabilities. 16-core max.

 

If you want to get your hands on SQL 2012 ahead of time, you can download a flavor via Microsoft with their CTP3 version (community technology preview) via this link.

Under the Hood

Microsoft has added big data processing capabilities with SQL Server 2012, based on Apache Hadoop.  There are also new touch based data exploration features extended to Apple iOS devices.  Interest in Hadoop is driven by the need for handling of large volumes of data which is often loosely structured, as with social network feeds or web logs.

Microsoft is supporting Hadoop via an Apache spinoff that will run as a service on their cloud platform Azure and on Windows Server.  Azure is due to debut in beta by later this year, with a release in 2012.

Essentially with this is new territory for Microsoft, running an open source application that was previously run on Linux.  Microsoft has not revealed if there will be the ability to support appliances on third-party software down the road.

 
SQL 2012 Requirements

  •  Must run NTFS file system (upgrades from Fat32 supported)
  • Cannot be installed on read-only, mapped or compressed drives
  • .NET 3.5 SP1 (for Database Engine, Reporting Services, Data Quality Services, Master Data Services, Replication, or SQL Server Management Studio) via Server 2008 features or install manually
  • .NET 4.0 gets installed as part of the setup
  • PowerShell v2

Software

Requirement

Framework

  • .NET Framework 4
  • .NET Framework 3.5 SP1
  • SQL Native Client
  • SQL Setup support files

Network Related

Requirements for the x64 versions of MS SQL Server 2012 are the same as the requirements for the x86 versions.  Supported OS have builtin network software. Standalone named and default instances support the following network protocols:

  • Shared memory
  • Named Pipes
  • TCP/IP
  • VIA

Virtualization

MS SQL Server 2012 is supported in VM environments running on the Hyper-V role in Server 2008 SP2 Standard Enterprise and Datacenter editions, VMWare support is not announced at the moment.

Here are recommended practices when using VMs:

  • We highly recommend that MS SQL Server 2012 is shut down manually prior to shutting down the VM.
  • Guest failover-clustering is supported in MS SQL Server 2012.

HardDisk

Disk space requirements will vary with the MS SQL Server 2012 components you install.

 

Hardware Requirements:

  • Supported OS:  Server 2008 R2 SP1, Windows 7 SP1, Server 2008 SP2, and Windows Vista SP2.
  • Processor:
    • Minimum requirement for x64 installations: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support. Processor Speed: 1.4 GHz
    • Minimum requirement for x86 installations: Pentium III compatible or higher. Processor Speed: 1.0 GHz
  • Memory: Minimum requirement: 1 GB

 

MSSQL Server 2012 Express

  • Supported OS: Server 2008 R2 SP1,Server 2008 SP2, Windows 7 SP1, and Windows Vista SP2.
  • Processor:
    • Minimum requirement for x64 installations: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support. Processor Speed: 1.4 GHz
    • Minimum requirement for x86 installations: Pentium III compatible or higher. Processor Speed: 1.0 GHz
  • Memory: Minimum requirement: 512 MB

 

Other Notes:

WOW64 (Windows x86 on Windows x64) is part of x64 editions of Windows, that enables x86 applications to run natively in x86 mode. Applications function in x86 mode, even when the underlying operating system is x64. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations.

For SQL Server x64 on x64 supported OS, Management Tools are supported in WOW64.

On a supported x64 operating system, SQL Server x86 edition installations can be installed to the WOW64 x86 subsystem of ax64server.

SQL Server editions that are supported on Server 2008 R2 x64.  x64 Standard are also supported on Windows Small Business Server x64.

MS SQL Server 2012 is now supported on Windows 2008 R2 SP1 server core operating system.  Server core functionality is available on the following Server 2008 R2 editions:

  • Server 2008 R2 SP1 x64 Datacenter
  • Server 2008 R2 SP1 x64 Enterprise
  • Server 2008 R2 SP1 x64 Standard
  • Server 2008 R2 SP1 x64 Web

Paths supported to upgrade existing SQL Server

  • SQL Server 2005 SP4 or later;
  • SQL Server 2008 SP2 or later
  • SQL Server 2008 R2 SP1 or later

How do the hardware requirements compare to SQL 2008?

  • 2008 required a Pentium 3 or faster CPU (x86 or x64), min of 1GHz, recommended 2GHz, with RAM at a minimum of 512MB, but recommended 2GB or more.
  • Enterprise 2008 R2 allowed a max of 8 sockets / cpu's and up to 256 logical processors (OS limitation).
  • Windows 8 announced as supporting 640 logical processors, so SQL 2012 may later be enhanced to allow for 640 logical processors as well.

Source:Microsoft


Use this QR code in a QR reader application on mobile to open quickly on a mobile device

blog comments powered by Disqus

Flight-Stew Now Live

Be sure to visit our newest site, Flight-Stew, now active!

Recently Added

Subscribe

Poll

Which Game Console will you buy?


Show Results

[forcestyle][nozoom][nocaption]

Donate

       Support Tech-Stew
   [nozoom]
        Make a Donation

Recent Comments