I need to retrieve some value from 100 different servers trough DBLINK. This connection is trough a VPN on Internet.
Each call take time, and the total off the 100 call take 5 minutes.
I would write a SQLCLR proc and work with a ThreadPool to execute many call on the same time.
It's possible, you have some simple sample or a guide line.
Thank for your help.