interview purpose i want answers

Posted by Ramana under Interview Questions on 3/16/2012 | Points: 10 | Views : 854 | Status : [Member] | Replies : 2
application pool and connection poll? how and where define connection poll size?


Posted by: Hmanjarawala on: 3/16/2012 [Member] Bronze | Points: 25


An application pool is a configuration that links one or more applications to a set of one or more worker processes. Because applications in an application pool are separated from other applications by worker process boundaries, an application in one application pool is not affected by problems caused by applications in other application pools.

By creating new application pools and assigning Web sites and applications to them, you can make your server more efficient and reliable, as well as making your other applications always available, even when the worker process serving the new application pool has problems.

A database connection pool is a set of database connections that are held open with the database and are kept ready to serve. This way, a set of connections is created once the pool comes into existence. When a user requests a connection, an already created connection is served from the pool. Similarly, when a user closes a connection, it is returned to the pool instead of being destroyed. This can significantly improve the performance of data access.

For more reference:
Connection pooling :

Application pooling :

Connection pool size define in connection string in "MaxPoolSize" attribute bydefault its value is 100

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere

Ramana, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 3/17/2012 [Member] Starter | Points: 25

Login to post response