our pools are getting maxed out by one of our programs/routines...and we cannot identify which program is running that is causing this...does anyone offer phone consulting or know of a program that we can run that can identify which program or function is causing this.
asked Jun 17, 2011 at 04:15 PM in Default
The quickest way would be to identify the source/login.
You can use this SP to see where the connections are been used.
If you want deeper details of the connections then Adam Mechanics [script] is a perfect way to do so: http://sqlblog.com/files/folders/35240/download.aspx
answered Jun 17, 2011 at 05:16 PM