I create a small sql pool with java program, the idea is the pool has a limited connection number, some transaction can work in that pool for a while. if this program hook up with MYSQL, the connection number always same as the pool limit, howerver, if work with SQL Server, the user connection number is larger than the limit. Could you share some SQL Server info about that or java sql with SQL Server?
