High Availability (HA)

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,136 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

2021-08-25

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

4,340 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

Calender Error in SSRS with SSAS Tabular Source

By RADISSOUFAN

I have a report which get a Date Parameter.. I don't want to display...

Calender Error in SSRS with SSAS Tabular Source

By RADISSOUFAN

I have a report which get a Date Parameter.. I don't want to display...

Best CI/CD or release process

By sqlenthu 89358

Hello my SQL friends, I want to know about few of the best approaches/methodologies/applications...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers