January, 2012

One of the most frequent questions I get asked from customers is which high availability capabilities are available in which editions of SQL Server 2012. Here are details of SQL Server 2012 Editions and the capabilities: http://www.microsoft.com/sqlserver...

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery http://msdn.microsoft.com/en-us/library/hh781257.aspx Summary : This white paper discusses how to reduce planned and unplanned downtime, maximize application...

Prepare SQL Server for using AlwaysOn feature To support AlwaysOn Availability Groups feature, an instance of SQL Server must meet the following prerequisites: The server instance must be running an edition of SQL Server that supports AlwaysOn...

Converting Log Shipping Configurations to a New Availability Group Let's take a scenario where you already have a log shipping configuration. You have three databases (db1, db2, and db3) that are set up for log shipping among three different data centers...

Several dozen customers are already running SQL Server 2012 AlwaysOn in production. We have published case studies with some of these reference customers. Mediterranean Shipping Company (MSC) : http://www.microsoft.com/casestudies/Microsoft-SQL-Server...

Matt Neerincx from the SQL Server Connectivity team introduces the AlwaysOn Availability Group Listener. Covers the AlwaysOn Availability Group Listener feature and how it works with the AlwaysOn Availability Groups to provide connectivity. Discusses...

Please refer to http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-setting-up-readable-seconary-replica.aspx Thanks Sunil Agarwal

Please refer to http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-why-there-are-two-options-to-enable-a-secondary-replica-for-read-workload.aspx Thanks Sunil Agarwal

Please refer to http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson.aspx Thanks Sunil Agarwal

Please refer to http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-impact-on-the-primary-workload-when-you-run-reporting-workload-on-the-secondary-replica.aspx Thanks Sunil Agarwal

Please refer to http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-minimizing-blocking-of-redo-thread-when-running-reporting-workload-on-secondary-replica.aspx Thanks Sunil Agarwal

Please refer to http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-impact-of-mapping-reporting-workload-to-snapshot-isolation-on-readable-secondary.aspx Thanks Sunil Agarwal

Please refer to http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-challenges-with-statistics-on-readonly-database-database-snapshot-and-secondary-replica.aspx Thanks Sunil Agarwal

Please refer to http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-making-upto-date-statistics-available-on-readable-secondary-read-only-database-and-database-snapshot.aspx Thanks Sunil Agarwal

Please refer to http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-i-just-enabled-readble-secondary-but-my-query-is-blocked.aspx Thanks Sunil Agarwal

Please refer to http://blogs.msdn.com/b/sqlserverstorageengine/archive/2012/01/22/alwayson-comapring-readble-secondary-with-the-similar-functionality-available-in-db2.aspx Thanks Sunil Agarwal

Please refer to the following blogs http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-value-proposition-of-readable-secondary.aspx Thanks Sunil Agarwal

SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery solution for your application. Please refer to blog: http://sqlcat.com/sqlcat/b/msdnmirror/archive/2011/12/22/sql-server...