February 27, 2024 at 1:05 pm
I've SQL Server 2019 Always On cluster (latest CU) that has 4 network adapters. Two of the are teamed as production network and two adapters for iSCSI networks. I'm using (hallengren.com) scripts for backup. The destination where backups are saved has same kind of network adapter configuration. Backups are working ok, but I wonder why I see heavy network traffic on all adapters during backup?
Backup is configured to use only one adapter
@Directory = '\\192.168.42.116\backup$\Staging',
Production network has subnet 10.101.54.0/24
iSCSI has subnets 192.168.42.0/24 and 192.168.43.0/24
Using netstat on the destination server I can see that sessions are open from both adapters
TCP 10.101.54.21:445 STAG-SQL-02:59488 ESTABLISHED
TCP 192.168.42.116:445 iscsi1-stag-sql02:56823 ESTABLISHED
Is there way to force backup to use only specific networks? The goal is to get backup traffic out of the production network
February 28, 2024 at 7:18 am
MPIO (Multipath IO) is enabled on server. Could that be the reason for behavior?
June 25, 2024 at 3:54 pm
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply