SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag always on Rss

Search for any content tagged always on

   Items 1 to 20 of 58    Older >>
 

Configuring SQL Server Always on Azure Servers(Iaas)

Configuration of SQL Server Always on in Azure Virtual machines differs in multiple ways comparing with the on-premise Implementations. This article will help you to have a handy note to configure always on in Azure servers from a DBA perspective.  Read more...
By Vishnu Gupthan 2018/12/06 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 231 reads

Always On - Endpoint Ownership

Whoever creates an AlwaysOn group is, by default, the owner of the endpoint. This is generally not a problem…unless that person leaves the company and you need to delete the login.  Read more...
By Ginger Keys Daniel 2018/10/25 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 532 reads

Stairway to AlwaysOn Crossword

This crossword puzzle is based on the contents of the Stairway to AlwaysOn.  Read more...
By Kenneth Fisher 2018/07/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 49 reads

Configure Read Only Routing

The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.   Read more...
By Ganapathi varma Chekuri 2018/02/05 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 708 reads

Stairway to AlwaysOn Level 4: Analyse and Deploy a Windows Server Failover Cluster

In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2017/11/08 (first published: 2014/12/10) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 5,169 reads

Stairway to AlwaysOn Level 3: Infrastructure 101

In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2017/11/01 (first published: 2014/10/29) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 7,009 reads

Network Configuration of SQL Server Always On Availability Groups in Azure

Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in the Microsoft cloud environment. In this article, Marcin Policht looks at the networking aspects of clustered deployments of SQL Server 2016 in Azure.  Read more...
By Additional Articles 2017/10/11 | Source: Database Journal | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 2,662 reads

Setup and Implement SQL Server 2016 Always On Distributed Availability Groups

SQL Server 2016 introduced a new feature called Distributed Availability Group. A Distributed Availability Group is a special type of Availability Group that spans two separate Availability Groups. Edwin Sarmiento explains.  Read more...
By Additional Articles 2017/09/08 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 4,030 reads

Stairway to AlwaysOn Level 2: Storage 101

In this new level of the stairway, we examine the storage knowledge you need for an AlwaysOn configuration.  Read more...
By Perry Whittle 2017/08/09 (first published: 2014/10/01) | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 7,584 reads

The Connection to the Primary Replica is not Active

In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.  Read more...
By Ganapathi varma Chekuri 2017/04/17 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 377 reads

Step by Step Configuring a Dedicated Network for Availability Group

In this article, I will show a procedure to isolate the replication traffic from the public network.   Read more...
By Ganapathi varma Chekuri 2017/04/10 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 689 reads

Step by Step Configuring AlwaysOn with Log Shipping

In this article, I will show you a procedure to combine SQL Server AlwaysOn with logshipping and to make log-shipping to work even in case of failovers between availability replicas in primary site.  Read more...
By Ganapathi varma Chekuri 2017/04/03 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 1,372 reads

Office Hours Webcast 2017/02/01

In this edition of Office Hours, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, their favourite high availability solutions, and more.  Read more...
By Additional Articles 2017/02/14 | Source: Brent Ozar Unlimited Blog | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 3,692 reads

Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster

A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.  Read more...
By Additional Articles 2017/01/13 | Source: MSSQLTips.com | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 3,238 reads

Maintenance Routines for AlwaysOn

How to determine what replica(s) to perform maintenance routines  Read more...
By Ginger Keys Daniel 2016/12/05 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 1,774 reads

SQL Server 2016 Distributed Availability Groups

High availability solution with cross cluster support using the new Distributed Availability Groups  Read more...
By Jennifer Brocato 2016/11/14 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 1,140 reads

TempDB growth due to version store on AlwaysOn secondary server

On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.  Read more...
By Ramya Makam 2016/11/07 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 1,491 reads

Resolving an Error When Creating an Availability Group Listener

In this post, I’m going to talk an issue that I found when creating an availability group listener by using SQL Server Management Studio's Add Listener. This article helps you to resolve the issue.   Read more...
By Ganapathi varma Chekuri 2016/09/06 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 845 reads

Installing Master Data Services in an AlwaysOn Environment

This article describes a solution for Master Data Service (MDS) hosted on AlwaysOn Availability Group configuration. The article describes how to install and configure SQL 2016 Master Data Services on a SQL 2016 AlwaysOn Availability group (AG). The main purpose of this solution is to improve high availability and disaster recovery of MDS backend data hosted on a SQL Server database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,131 reads

SQL Server AlwaysOn Endpoint Encryption Algorithm Compatibility Error

Ahmad Yaseen takes a look at how to deal with an endpoint encryption compatibility error when using SQL Server's AlwaysOn Availability Group Wizard.  Read more...
By Additional Articles 2016/06/08 | Source: MSSQLTips.com | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 2,478 reads
   Items 1 to 20 of 58    Older >>