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.