title: SQL Server connection string for big concurrent connection
body: <p>I've been searched this page : <a href="https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=vs.110).aspx" rel="nofollow">SqlConnection.ConnectionString Property</a></p>
  
  <p>But, I am not really sure the property that I should use. So far, I used <code>Max Pool Size</code> and <code>Pooling</code> property.</p>
  
  <p>I build REST API will be used by more than thousand user per minutes. I got bad result in insert query process (POST request). There are data not successfully inserted to the table. How can SQL Server handle this problem? At least from connection string property. Tell me if connection string can't help too.</p>
  
  <p><strong>Update</strong>: my connection string:</p>
  
  <pre><code>&lt;add name="DefaultConnection" 
       providerName="System.Data.SqlClient" 
       connectionString="Server={my_server},1433;Database={my_db};User ID={my_user};Password={my_password};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;Max Pool Size=1000;Pooling=true;" /&gt;
  </code></pre>