What is connection pooling in SQl Server?

Posted by Pkanwar under Sql Server on 9/24/2013 | Points: 10 | Views : 991 | Status : [Member] | Replies : 7
What is connection pooling in SQl Server? Please Explain how to work it in SQL


Thanks




Responses

Posted by: Bandi on: 9/24/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
http://www.mssqltips.com/sqlservertip/1830/script-to-check-sql-server-connection-pooling/
http://www.pythian.com/blog/sql-server-understanding-and-controlling-connection/
http://www.sqlskills.com/blogs/bobb/sql-server-and-pooled-vs-non-pooled-connections/
http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx


Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

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

Posted by: aswinialuri-19361 on: 9/25/2013 [Member] Starter | Points: 25

Up
0
Down
HI,
refer this link i hope it might be helpful to you

http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx

Mark as Answer if it helps you
Thanks&Regards
Aswini Aluri

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

Posted by: Pkanwar on: 9/25/2013 [Member] Starter | Points: 25

Up
0
Down
Above link is not related to connection pooling.Its not helpful regarding to it.

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

Posted by: Bandi on: 9/25/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
"Mark as answer " if you understood the connection-pooling

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

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

Posted by: aswinialuri-19361 on: 9/25/2013 [Member] Starter | Points: 25

Up
0
Down
hi
refer this link it might be helpful to you

http://consultingblogs.emc.com/jamesrowlandjones/archive/2009/07/25/how-to-tell-if-connections-to-sql-server-are-pooled-or-not.aspx

Mark as Answer if it helps you
Thanks&Regards
Aswini Aluri

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

Posted by: aswinialuri-19361 on: 9/25/2013 [Member] Starter | Points: 25

Up
0
Down
hi pkanwar,
you can check it now i have edited that response

Mark as Answer if it helps you
Thanks&Regards
Aswini Aluri

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

Posted by: Bandi on: 9/25/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
The following link clear your doubt on connection pooling...
http://stackoverflow.com/questions/9922675/sql-server-where-is-connection-pool-on-net-side-or-server-side



Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

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

Login to post response