Microsoft SQL Server 2014
Microsoft SQL Server 2014 builds on the mission-critical capabilities delivered in the prior release by providing breakthrough performance, availability and manageability for your mission critical applications. SQL Server 2014 delivers new in-memory capabilities built into the core database for OLTP and data warehousing, which complement our existing in-memory data warehousing and BI capabilities for the most comprehensive in-memory database solution in the market.
SQL Server 2014 also provides new disaster recovery and backup solutions with Windows Azure, enabling customers to use their existing skills with the on-premises product offerings to take advantage of Microsoft’s global datacenters. In addition, SQL Server 2014 takes advantage of new Windows Server 2012 and Windows Server 2012 R2 capabilities to give you unparalleled scalability for your database application in a physical or virtual environment.
SQL Server 2014 also provides new disaster recovery and backup solutions with Windows Azure, enabling customers to use their existing skills with the on-premises product offerings to take advantage of Microsoft’s global datacenters. In addition, SQL Server 2014 takes advantage of new Windows Server 2012 and Windows Server 2012 R2 capabilities to give you unparalleled scalability for your database application in a physical or virtual environment.
SYSTEMS requirements
he following requirements apply to all SQL Server 2012 installations:
Component
|
Requirement
| ||
|---|---|---|---|
.NET Framework
|
.NET 3.5 SP1 is a requirement for SQL Server 2012 when you select Database Engine, Reporting Services, Master Data Services, Data Quality Services, Replication, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup.
.NET 4.0 is a requirement for SQL Server 2012. SQL Server installs .NET 4.0 during the feature installation step.
| ||
Windows PowerShell
|
SQL Server 2012 does not install or enable Windows PowerShell 2.0; however Windows PowerShell 2.0 is an installation prerequisite for Database Engine components and SQL Server Management Studio. If Setup reports that Windows PowerShell 2.0 is not present, you can install or enable it by following the instructions on the Windows Management Framework page.
| ||
Network Software
|
Supported operating systems for SQL Server 2012 have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, TCP/IP and VIA.
For more information about Network Protocols and Network Libraries, see Network Protocols and Network Libraries.
| ||
Virtualization
|
SQL Server 2012 is supported in virtual machine environments running on the Hyper-V role in:
In addition to resources required by the parent partition, each virtual machine (child partition) must be provided with sufficient processor resources, memory, and disk resources for its SQL Server 2012 instance. Requirements are listed later in this topic.1
Within the Hyper-V role on Windows Server 2008 SP2 or Windows Server 2008 R2 SP1, a maximum of 4 (four) virtual processors can be allocated to virtual machines running Windows Server 2008 SP2 32-bit/64-bit or Windows Server 2008 R2 SP1 64-bit or Windows Server 2012 64-bit editions.
Within the Hyper-V role on Windows Server 2012,
For more information on compute capacity limits for different editions of SQL Server 2012 and how they differ in physical and virtualized environments with hyperthreaded processors, seeCompute Capacity Limits by Edition of SQL Server. For more information about the Hyper-V role, see the Windows Server 2008 Web site.
Notes:
| ||
Internet Software
|
Internet Explorer 7 or a later version is required for Microsoft Management Console (MMC), SQL Server Data Tools (SSDT), the Report Designer component of Reporting Services, and HTML Help.
| ||
Hard Disk
|
SQL Server 2012 requires a minimum of 6 GB of available hard-disk space.
Disk space requirements will vary with the SQL Server 2012 components you install. For more information, see Hard Disk Space Requirements (32-Bit and 64 Bit) later in this topic. For information on supported storage types for data files, see Storage Types for Data Files.
| ||
Drive
|
A DVD drive, as appropriate, is required for installation from disc.
| ||
Monitor
|
SQL Server 2012 requires Super-VGA (800x600) or higher resolution monitor.
| ||
Internet
|
Internet functionality requires Internet access (fees may apply).
|
Note
1Running SQL Server 2012 on a virtual machine will be slower than running natively because of the overhead of virtualization.
The following memory and processor requirements apply to all editions of SQL Server 2012:
Component
|
Requirement
|
|---|---|
Memory[1]
|
Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
|
Processor Speed
|
Minimum:
Recommended: 2.0 GHz or faster
|
Processor Type
|
|
[1]The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server 2014 minimum memory requirement. For information about installing DQS, see Install Data Quality Services.
No comments:
Post a Comment