<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gd="http://schemas.google.com/g/2005"><id>tag:blogger.com,1999:blog-4500363753981919783.post4208750373644986048..comments</id><updated>2023-10-03T22:06:50.708+08:00</updated><title type='text'>Comments on Huan-Lin 學習筆記: .NET Connection Pool 與連線相關問題整理</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://www.huanlintalk.com/feeds/comments/default'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4500363753981919783/4208750373644986048/comments/default'/><link rel='alternate' type='text/html' href='https://www.huanlintalk.com/2012/05/net-connection-pool.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><author><name>Michael Tsai</name><uri>http://www.blogger.com/profile/00364693770445538641</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>1</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-4500363753981919783.post-3757997785860341721</id><published>2013-04-20T17:36:59.476+08:00</published><updated>2013-04-20T17:36:59.476+08:00</updated><title type='text'>http://blogs.msdn.com/b/kaevans/archive/2009/04/09...</title><content type='html'>http://blogs.msdn.com/b/kaevans/archive/2009/04/09/linq-to-sql-and-connection-pooling.aspx<br /><br />One thing to look at is how you are forming the connection string. If you have any variation in your connection string (using different user names in the string, for example), it can lead to an exhaustion of resources. The common guidance is to use a single connection string stored in the configuration file that uses integrated authentication (does not contain a user ID or password in the query string, the identity is determined based on the identity of the IIS application pool user account). A way to get an idea of the connections and processes is to go into SQL Server Management Studio and run the following query:</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/4500363753981919783/4208750373644986048/comments/default/3757997785860341721'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/4500363753981919783/4208750373644986048/comments/default/3757997785860341721'/><link rel='alternate' type='text/html' href='https://www.huanlintalk.com/2012/05/net-connection-pool.html?showComment=1366450619476#c3757997785860341721' title=''/><author><name>Areca Chen</name><uri>https://www.blogger.com/profile/09525284218463771638</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSQxh4iRAWFL5ptLPxH3B-5aJD-eRrL7FB1mUhQSt5WvtnRqtLZLeZYxsd-K3X73S5efhSts0FShBP4oPgbjmwp5djenYGdDXvj4PT9kHPoeWjsrHNQbh-Ex0uQqPRcR4/s220/%E6%88%91%E7%9A%84%E7%85%A7%E7%89%87.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.huanlintalk.com/2012/05/net-connection-pool.html' ref='tag:blogger.com,1999:blog-4500363753981919783.post-4208750373644986048' source='http://www.blogger.com/feeds/4500363753981919783/posts/default/4208750373644986048' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2093599219"/><gd:extendedProperty name="blogger.displayTime" value="2013/4/20 下午5:36"/></entry></feed>