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 replicas, the network performance will be pretty poor. This article will look at adding a second NIC to the SQL Server to segregate the traffic.
Before reading my article you must master how to build a common AOAG at first.
Solution
Add a second NIC