Connection Pooling Explained

Connection Pooling Explained

I found very interesting article on connection pooling in ASP.net.
If you want to understand what is connection pooling,
refer
http://ondotnet.com/pub/a/dotnet/2004/02/09/connpool.html

It gives solid proof of what exactly happens when you open connection with your Data base server using ADO.net
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.
refer
www.connectionstrings.com

Satalaj

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 Asp.netasp.net connectionInternet connection not respondingASp.net 2.0 step by step Membership Provider C# read excel xlsx 2007transaction

Author

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 ASP.net 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.