Link to home
Start Free TrialLog in
Avatar of sharepoint0520
sharepoint0520

asked on

Max pool and time out for SQL connection string?

Experts,
 We have created one application by using sharepoint  and SQL server. We have 2 billion data in SQL server and we are using SQL connection string to pull data to sharepoint application page. Now near 20000 thousand users going to use this application. I would like to know some assumptions for connection string setting for Max pool and Time out.

1.what is the max connection pool
2.What is the  risk of not using any timeout or Max pool size
3. What is recommended limit for connection pool for 1000 concurrent users

We expect 1000 concurrent  users to access this application. Please advice.
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sharepoint0520
sharepoint0520

ASKER

Thank you Raja. I just wanted to clarify that we created custom application with .net  framework and used below connection. And we used client side code by javascript and rest API to read data from application page. So data we are displaying from SQL server though service account.

<add connectionString="Server=server1;Database=db11;Integrated Security=true" name="test" />

Do you think should we set up Max Pool and Timeout for this connection string?
Okay, got it..
Connection timeout value is 15 seconds by default if you don't specify any thing..
I really wonder whether you really would have 1000 concurrent users using your application.. if so, then kindly specify both Min and Max Pool size to 1000 and 2500 to start with..
Just a question - if you built a .net application, why are you using SharePoint also?
Business uses sharepoint and for this web application we used LADP authentication. They also use some sharepoint functionality along with this. And we uses only client side coding so that is why first we created the application page to pull SQL data to sesssion and from application page we reading data with rest api.
Raja,
 We have 4 core cpu and 32 GB ram. Do you think do we need to set Timeout and Max pool properties?
Thanks for the info. Sounds like you have a nice setup.

Good luck...
Thanks for the Server info..

>> Do you think do we need to set Timeout and Max pool properties?

As mentioned above, Timeout value is configured by default to 15 seconds and hence no need to set it unless we want to change it to some other value.
And set both the Min and Max Pool size to 1000 and 2500 to start with.
Thanks a lot Raja. One more thing to clarify. As i mention we created the application page project in visual studio for our sharepoint farm to read data from SQL. (https://docs.microsoft.com/en-us/visualstudio/sharepoint/walkthrough-creating-a-sharepoint-application-page?view=vs-2017)

And we have used the basic connection string to pull data. You have suggested that we should set Min and Max Pool size to 1000 and 2500 to start with for 1000 concurrent users.  What is the  risk of not using  Max pool size? By Default it takes 100 Max value?

Please advice

Thanks again for all information.
>> What is the  risk of not using  Max pool size? By Default it takes 100 Max value?

Yes, by default Min and max pool size would be set as 0 and 100..
If not configured above 100, then your application can establish a max of 100 connections at any point in time and any new db connection request when these 100 sessions are in use will get an error message saying "Max Connection pool size reached".
https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectionstring?view=netframework-4.7.2
Thank you Raja
Welcome..