In SQL Server 2014 is there a way to group connections by the connection pool that belong to? We are trying to find out if a specific application is leaking connections and hitting the default max pool size of 100.
In this doc on Connection Pooling it states that each pool is defined by the exact connection string used to establish the connection. However, I am unable to find anything in the sys table that allows me to see that.
The closest I have groups by loginname and program_name:
select rtrim(p.loginame) ,p.program_name ,count(*) from sys.sysprocesses p group by p.loginame, p.program_name order by count(*) desc
Thanks in advance!