I am trying to implement the Connection Pool in my project. I need to count the number of connection that i need at a particular time so that i can set the maximum limit of connection for connection pool. Can any one guide me how can i check, how many connections are using at a particular time.
Asked
Active
Viewed 1,226 times
0
-
2Why do you want to implement your own connection-pool if there's [already one](http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx)? – Tim Schmelter Aug 19 '13 at 11:26
-
i am not trying to implement another Connection pool but i just want to know that how many connections are opened at a particular time. Means i want some graphical representation that at this point the connection usage was more and at this point it was low. So that i can set the maximum and minimum limit of connection pool in web.config. – Himanshu Jain Aug 19 '13 at 11:58
-
What rdbms are you using? – Tim Schmelter Aug 19 '13 at 12:00
-
I am using Sql Server 2008 – Himanshu Jain Aug 19 '13 at 12:15
-
2http://stackoverflow.com/a/216020/284240 or http://stackoverflow.com/questions/4487671/get-number-of-open-connection-string-in-my-application – Tim Schmelter Aug 19 '13 at 12:21