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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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..
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?
ASKER
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.
ASKER
Raja,
We have 4 core cpu and 32 GB ram. Do you think do we need to set Timeout and Max pool properties?
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...
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.
>> 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.
ASKER
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.
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
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
ASKER
Thank you Raja
Welcome..
ASKER
<add connectionString="Server=s
Do you think should we set up Max Pool and Timeout for this connection string?