title: How to set Max Pool Size of SqlConnection string in c# on asmx web service?
body: <p>I have a physical server with SQL Server 2008 installed on it. Recently <code>sqlservr.exe</code> consumes excessive CPU and RAM.</p>
  
  <p>When I investigated the reasons for this, I learned that it was due to the links opened and that the pool setting was enabled.</p>
  
  <p>All my connections to my database are in a single asmx file, so there is no other connection string.</p>
  
  <p>Here is my connection string</p>
  
  <pre><code> Server=server;Database=dbxxx;User Id=sas;Password=sssxxxx;Max Pool Size=1000;
  </code></pre>
  
  <p>The program that connects to this web service uses approximately 3 to 4 thousand users per day. The web service daily runs approximately 20 thousand SQL queries per day.</p>
  
  <p>The presenter has 8 gb of RAM and he gets to use 7 gb ram right in the morning with no decrease in usage from 1.7 gb in the morning, or even ever increasing.</p>
  
  <p>How should max pool be set up because you have a single web service connection? Do I do the right thing or is there something extreme?</p>