SQL Server Always on

Topics: High availability, Database, Downtime Pages: 2 (291 words) Published: December 18, 2013
SQL Server 2012 provides everything you need to address availability and reliability of data at every level of the enterprise – at the right price and at the right time.

What's New in SQL Server 2012
Help reduce planned and unplanned downtime with the new integrated high availability and disaster recovery solution, SQL Server AlwaysOn. Simplify deployment and management of high availability requirements using integrated configuration and monitoring tools. Improve IT cost efficiency and performance using up to four Active Secondary. Reduce planned downtime with Windows Server Core.

Key Capabilities

Implement High Availability and Disaster Recovery

Achieve the required 9’s with new SQL Server AlwaysOn.
Comprehensive Technologies for High Availability and Disaster Recovery

Set up Availability Group with the ability to failover multiple databases as a unit to ensure the availability of all databases in the application. Provide an integrated set of options, and seamless application failover with the Availability Group Listener feature. Easily monitor the high availability configuration using AlwaysOn dashboard, a visual configuration of the health of your database. Enhance SQL Server failover clustering and support multi-site clustering across subnet to enable cross-datacenter failover of SQL Server instances. Help control when a failover should happen and eliminate false failover of instances and databases.

Eliminate Idle Secondary Hardware

Improve performance by redirecting reporting workloads, utilizing secondary hardware, and freeing up capacity on the primary hardware. Gain near real time reports and rapid query performance for reporting queries with fast data replication and creation of auto statistics. Achieve seamless redirection of reporting applications to a new secondary one using read-only routing in the event of a failure. Improve capacity utilization on the secondary hardware by offloading backup jobs to the Active Secondary....
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Sql Server
  • SQL Server Notes Essay
  • Sql Server Installation Process Essay
  • sql server notes Essay
  • Back and Restore Using Sql Server Essay
  • Sql Server
  • Database Sql Server Research Paper
  • SQL vs. Oracle Essay

Become a StudyMode Member

Sign Up - It's Free