PI as linked server and connection pool

Discussion created by jmolines on Feb 23, 2012
Latest reply on Feb 27, 2012 by spilon

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.