Database System | Performance & Scalability | SQL Server 2012 Enterprise Edition

About SQL Server
Solutions & Technologies
- - Solutions & Technologies
    
    Solutions & Technologies Overview
  - Hybrid IT
    
    Hybrid IT Overview
    
    Developer Tools
    
    Interoperability
    
    Private Cloud
    
    Public Cloud
- - BI and Big Data
    
    BI and Big Data Overview
    
    Analysis
    
    Big Data
    
    Office Based Tools
    
    Predictive Analytics
    
    Reporting
    
    Streaming Data
  - Enterprise Information Management
    
    Enterprise Information Management Overview
    
    Data Quality Services
    
    Integration Services
    
    Master Data Services
- - Data Warehousing
    
    Data Warehousing Overview
    
    Software
    
    Parallel Data Warehouse Appliance
    
    Reference Architecture
  - Mission-Critical Operations
    
    Mission-Critical Operations Overview
    
    High Availability
    
    I/O Reliability Partner Program
    
    Manageability
    
    Performance & Scalability
    
    Security & Compliance
- - In-Memory
    
    In-Memory Overview
  - Appliances
    
    Appliances Overview
    
    HP AppSystem For PDW
    
    Dell PDW Appliance
    
    Dell Quickstart DW Appliance
Editions
- - Business Intelligence Edition
  - Compact Edition
- - Standard Edition
  - Parallel Data Warehouse Appliance
Get SQL Server
- - Get SQL Server Overview
- - Try It
- - How to Buy
Learning Center
Partners
- - Partners
    
    Partners Overview
    
    Find a Partner
    
    Become a Partner
- - Featured Partners
    
    HP
    
    SAP
    
    Hortonworks

Enterprise edition

The premium offering, SQL Server 2012 Enterprise delivers comprehensive high-end datacenter capabilities for demanding database and business intelligence requirements.

Enterprise for mission critical applications and large scale data warehousing

New SQL Server 2012 Enterprise Edition Capabilities

Previous Next

SQL Server AlwaysOn
A new unified HA solution for greater uptime, faster failover, and better use of hardware resources.
xVelocity
Helps enable a generational leap in performance across data warehousing and business intelligence.
Power View
A highly interactive data exploration and visualization tool for users of all levels that helps enable insights at the speed of thought.
Data Quality Services
Improve data quality by using organizational knowledge and 3rd party reference data providers to profile, cleanse, and match data.
Distributed Replay
Production-like application testing enables high scale out testing for mission critical apps, configuration changes, and upgrades.
Enhanced Audit
Increase manageability related to auditing with audit resilience, filtering, user-defined audit, and enablement across all editions.

Things You Can Do

Run Demanding Workloads
Today’s world of continuous services and connected devices demands that applications and data will be up and available. SQL Server 2012 Enterprise is designed to support today’s demanding applications with built-in mission critical capabilities.
Required 9s
- Deliver required uptime and data protection, server to cloud without wasting time and money. New SQL Server AlwaysOn is a unified high availability and disaster recovery solution that helps deliver greater uptime, faster failover, and gain better use of hardware resources.
Blazing-Fast Performance
- Gain predictable and next-generation performance backed by customer, partner and industry-leading benchmarks. Experience up to 10-100x improvements in performance with xVelocity in-memory technologies for both Data Warehousing and Business Intelligence while speed built into the engine helps enable fast access to data within unstructured data.
Organizational Compliance and Security
- Help enable security and compliance with built-in security and IT controls. Increased manageability related to auditing with audit resilience, filtering, user-defined audit, and enablement across all SQL Server editions helps better facilitate compliance while new fine-grained control over data access can better support data access policies.
Peace of Mind
- Help ensure peace of mind with the right product tools, premier services and support offerings, a trusted partner ecosystem, and a wealth of no-fee tools. SQL Server 2012 delivers capabilities and programs that help ensure last mile excellence like new Distributed Replay for production-like testing, updated management packs for System Center Operations Manager, and Premier Support options.
Unlock Breakthrough Insights
With today’s unprecedented data explosion, organizations need to efficiently store, manage and unlock breakthrough insights within their data and across Big Data. SQL Server 2012 delivers the necessary capabilities to support scalable data warehousing, data cleansing and management, and rapid data exploration and visualization for end users. Enterprise includes all the BI functionality included in SQL Server 2012 Business Intelligence edition.
Rapid data exploration and visualization
- Discover new insights at the speed of thought with Power View, a highly interactive, familiar browser-based data exploration, visualization, and presentation experience for users of all levels, Additionally, PowerPivot helps empower users to access and mash-up data from virtually any source, including Big Data sources using familiar tools.
Managed self-service BI
- Balance the need to monitor, manage, and govern the data and analytics end users create with IT dashboards controls across SQL Server and Microsoft SharePoint that help IT monitor end user activity, data source usage, and gather performance metrics from servers. New to SQL Server 2012, IT can also transform end user-created BI applications in PowerPivot into corporate-grade solutions managed by IT.
Credible, consistent data
- With SQL Server 2012, IT can better control and manage data through a new BI Semantic Model and enhancements to SQL Server Integration Services. Meanwhile, new Data Quality Services uses organizational knowledge and 3rd party reference data providers to reliably cleanse data and a new Master Data Services Add-in for Excel makes it easier for end users to manage and maintain central data.
Big Data analytics and scalable data warehousing
- Help enable scale and flexibility with analytic and data warehouse solutions that offer massive scale at low cost. SQL Server 2012 supports structured data on scalable relational database and data warehouse offerings, and via Big Data connectors, supports unstructured data on an Enterprise-ready Hadoop distribution. Meanwhile data warehouse reference architectures and appliances can offer incredible price/TB and help speed time to solution.
Enable IT Ingenuity
SQL Server 2012 can help enable organizations quickly create and scale innovative Hybrid IT solutions across server, private or public cloud. Connection points in SQL Server 2012 make it easy to take advantage of Windows Azure Platform benefits glued together with common tools to build, extend, and manage practically anywhere.
Scale on Demand
- Scale on demand with flexible and hybrid deployment options, on your terms, server to cloud. Gain operational flexibility with proven Microsoft cloud offerings, private or public, that deliver interoperable deployment options with SQL Server 2012 Enterprise.
Optimized Productivity
- Optimize IT and developer productivity across server and cloud with common tools. New SQL Server Data Tools offers an integrated development experience across on-premises and public cloud. Additionally, Management Studio helps IT manage efficiently at scale with a wealth of database management tools, now with added support for snapshot backups to the cloud and connection points with Windows Azure SQL Database.
Extend Any Data, Anywhere
- SQL Server 2012 supports relational and non-relational data, including Big Data sources like Hadoop. Additionally, customers can extend heterogeneous environments using any industry standard APIs (ADO.NET, ODBC, JDBC, PDO, and ADO) across varied platforms including .NET, C/C++, Java, Linux, and PHP.