Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Availability Groups Rss

Search for any content tagged availability groups

   Items 1 to 8 of 8   
 

AlwaysOn in SQL Server 2014 CTP1

AlwaysOn encompasses the SQL Server solutions for mission-critical high availability and disaster recovery. Two solutions were included under the AlwaysOn umbrella in SQL Server 2012: Availability Groups and Failover Cluster Instances. Each solution has different characteristics, making them appropriate for different scenarios, and both can be combined in the same deployment.  Read more...
By Additional Articles 2013/07/25 | Source: MSDN Communities | Category: sql server 2014
Rating: (not yet rated)  Rate this |   Briefcase | 2,361 reads

Are my actual worker threads exceeding the sp_configure 'max worker threads' value?

Tom Stringer (@SQLife) was working on some HADR testing for a customer to simulate many availability groups and introduce significant load into the system to measure overhead and such. In his quest to do that he was seeing behavior that he couldn’t really explain and so worked with him to uncover what was happening under the covers.   Read more...
By Additional Articles 2013/07/23 | Source: MSDN Communities | Category: availability groups
Rating: (not yet rated)  Rate this |   Briefcase | 2,780 reads

PowerShell vs GUI Availability Group Rebuild

Windows Cluster\SQL Availability Group rebuild times comparison - Management Studio & Cluster Manager Vs PowerShell Commands   Read more...
By Paul Brewer 2013/06/17 | Source: SQLServerCentral.com | Category: windows cluster
Rating: |  Discuss |   Briefcase | 2,583 reads

Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell

With SQL Server 2012 AlwaysOn Availability Groups, you can configure read-only routing and to automatically redirect the read-only workloads to a secondary replica after a failover. Can this be done using Windows PowerShell?  Read more...
By Additional Articles 2013/04/17 | Source: MSSQLTips.com | Category: alwayson
Rating:  Rate this |   Briefcase | 1,377 reads

Backing Up SQL Server Databases Participating In Availability Groups

So I am using this new technology called Availability Groups that was introduced in SQL Server 2012. I have heard I can offload my backups to a secondary replica, but I am not sure how that works or how to configure those backups. Are there any limitations? Check out this tip to learn more.  Read more...
By Additional Articles 2013/02/25 | Source: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,246 reads

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups

SQL Server 2012 AlwaysOn Availability Groups provides a unified high availability and disaster recovery (HADR) solution that improves upon legacy functionality previously found across disparate features. Prior to SQL Server 2012, several customers used database mirroring to provide local high availability within a data center, and log shipping for disaster recovery across a remote data center. With SQL Server 2012, this common design pattern can be replaced with an architecture that uses availability groups for both high availability and disaster recovery. This paper details the key topology requirements of this specific design pattern, including quorum configuration considerations, steps required to build the environment, and a workflow that shows how to handle a disaster recovery event in the new topology.  Read more...
By Additional Articles 2012/08/31 | Source: Microsoft MSDN | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,838 reads

A first look at SQL Server 2012 Availability Group Wait Statistics

If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to many of the causes of problems. Although several wait types are documented, there is nothing like practical experiment to familiarize yourself with new wait stats, and Joe Sack demonstrates a way of testing the sort of waits generated by an availability group under various circumstances.  Read more...
By Additional Articles 2012/06/12 | Source: SimpleTalk | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,831 reads

Managing and Connecting to AlwaysOn Availability Groups

From the previous AlwaysOn Availability Group article, we provided a name for the availability group listener which is simply a unique DNS name as a Virtual Network Name (VNN) to direct read-write requests to the primary replica and read-only requests to the read-only secondary replica.   Read more...
By Additional Articles 2012/03/22 | Source: SQL Server Performance | Category: alwayson
Rating:  Rate this |   Briefcase | 1,518 reads
   Items 1 to 8 of 8