Connection Pooling Explained

Connection Pooling Explained

I found very interesting article on connection pooling in
If you want to understand what is connection pooling,

It gives solid proof of what exactly happens when you open connection with your Data base server using
default size of pool is 100.

you can also check with below query and perform the tests described in that article.

Using below query you can check number of connections opened to database and who opened it etc..  

select db_name(dbid) as DataBaseName , count(dbid) as  NoOFConnections , loginame as LoginName  from sys.sysprocesses 
                                                                                                                                                  where dbid > 0

                                                                                                                                                 group by  dbid,loginame


SELECT spid, uid=rtrim(loginame), Program_name=rtrim(Program_name),
dbname=db_name(dbid), status=rtrim(status) FROM master.dbo.sysprocesses
WHERE loginame = 'sa' and db_name(dbid) = 'APITest'
order by dbname


 To know, which connction string I should use with what data base providers.


Connection Pooling ExplainedJava connection poolingThis command requires an asynchronous connection Set Asynchronous Processing3dtrue in the connection stringasp net image uploadC# Read CSV FileConnectionStrings or appSettings in connectionInternet connection not 2.0 step by step Membership Provider C# read excel xlsx 2007transaction


My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.

I'm Satalaj.