Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Posts Tagged ‘alwayson’

What is AlwaysOn in SQL Server?

Posted by Paul on March 3, 2014

SQL Server 2012 introduced the new feature called AlwaysOn.

AlwaysOn provides High Availability & Disaster Recovery alternative to Database Mirroring.

What is Database Mirroring?

Database Mirroring is a technique to increase High Availability of database.  The topology consists of three server roles.

  1. Witness Server
  2. Principal Server
  3. Mirror Server 

Transaction Logs will be synchronized from Principal Server to Mirror Server.

image

The Witness Server determines whether to contact Principal or Mirror based on activity, thus increasing the availability.

Advantages of AlwaysOn over Database Mirroring

AlwaysOn provides the following advantages over Database Mirroring:

  1. More effective server utilization
  2. Less configuration hassles
  3. Better manageability
  4. Better failover situation
  5. Works best with multiple-database scenarios of SharePoint

More and More people are switching to AlwaysOn Availability Group technique.

References

AlwaysOn Experiment

Summary

Clustering, Mirroring, Log Shipping, AlwaysOn are different technologies to attain High Availability in database servers.

Advertisements

Posted in SharePoint, SharePoint 2010, SharePoint 2013, SQL Server | Tagged: , | Leave a Comment »