SQLTeam.com | Weblogs | Forums

How to use infinite band between 2 mssql?


#1

i had just install 2 mssql 2014 in to 2 server.
i had install infinite band betweem that 2 server.

Question.
How to specific use infinite band during query?


#2

Assuming your Windows servers are set up properly to use the infiniband connections, you would set up linked servers in each SQL instance pointing to the other, then perform a distributed query using four-part naming


#3

i just point to the destination server ip which is the infinite band, something like 10.10.10.1


#4

Is that a question or a solution?


#5

a solution, cause i had a infinite band between that 2 server.

i just create a linked server between 2 using that specific ip and query "select 1 go 1000000", monitor it from task manager and found that specific network is busy while both of the server is only me logged in.


#6

Great to hear!