Availability Group (AG)

SQLServerCentral Article

Add a Second NIC for an Availability Group to Separate Network Traffic

  • Article

Introduction Sometimes we face the scenario in an enterprise environment that the database in SQL Server Always On Availability Group (AOAG) has high concurrency read and write access from application servers. If we keep using the one network interface card for both network traffic of database connections from application servers and database mirroring between AOAG […]

4.75 (4)

You rated this post out of 5. Change rating

2023-05-08

2,562 reads

Technical Article

Always On Availability Groups Troubleshooting and Monitoring Guide

  • Article

This guide helps you get started on troubleshooting some of the common issues in AlwaysOn Availability Groups and monitoring AlwaysOn Availability Groups. It is intended to provide original content as well as a landing page of useful information that is already published elsewhere.

You rated this post out of 5. Change rating

2024-01-09 (first published: )

SQLServerCentral Article

A Step by Step Guide to the Availability Group (AG) Listener

  • Article

Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]

5 (1)

You rated this post out of 5. Change rating

2021-05-17

5,073 reads

SQLServerCentral Article

Steps for Installing AlwaysOn Availability Groups - SQL 2019

  • Article

With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made.  This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]

4.5 (2)

You rated this post out of 5. Change rating

2020-12-07

116,094 reads

Blogs

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Adding Git LFS Support – #SQLNewBlogger

By

I got this message recently while committing some changes: This post shows my work...

Read the latest Blogs

Forums

when peers maintain a job rdp'd in they corrupt the job

By stan

Hi, one of my peers prefers to maintain one specific sql agent job after...

import json file

By smattiko83

Any idea on how to import a json file into sql server? I've never...

Downside to running a query in parallel

By water490

I am a SS rookie.  To me it seems like running a query in...

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers