I am trying to create a very basic tool which would execute a script, retrieve the data and then write it into CSV. This needs to be done across 5000+ database servers. This can definitely be improved if it can be done in parallel. I was reading about Threads, ThreadPools and TPL and still confused which one should I be using. Any help would be much appreciated.
P.S. The number of parallel threads has to be configured within the tool