Currently there is an environment that has 4 servers with a database. I need to gather some information from 3 servers in 1.
Example :
The servers are: A B C and D
I need to get some information that is on the A B C servers and put it in the D .
My biggest concern now is with the optimization of this process as there are many data, the table of a database already has more than 1 million records.
Based on this, using the linked server would be best. The A B C servers send the information to D . Or does the D server fetch this data from other servers?
All databases are in SQL Server 2014.
INFRA DETAIL
- The version of Sql Server is 13.0.1601.5;
- The servers are all Windows Server 2012;
- Are on the same network;
- Server configuration is: Processor: Xeon E5 2GHz | 8 GB RAM memory | disk scsi;
- And there are several other processes running in the database;
UPDATE
- The SQL Server version is Enterprise;
- I have sysadmin user access;