jmolines

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.

Outcomes