Hi everybody !
I use PI as a linked server in SQL Server 2008 R2.
I access SQL Server using JDBC and I make parallel requests using 10 threads and a pool of connections.
I try to see how the number of connections in the pool influences my total execution time, but when my pool contains more than 2 connections, the total execution time of my requests stops decreasing, as if I couldn't parallelize more than 2 requests.
Could anyone give me a hint about where to look to solve this problem?
Thanks in advance.