Created
May 18, 2017 03:18
-
-
Save daltonnyx/9b28d1d4b4f1f6c1a068b659fd18c3a8 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//http://stackoverflow.com/questions/670774/how-can-i-solve-a-connection-pool-problem-between-asp-net-and-sql-server#670842 | |
You can specify minimum and maximum pool size by specifying MinPoolSize=xyz and/or MaxPoolSize=xyz in the connection string. This cause of the problem could be a different thing however. | |
XpoProvider=MSSqlServer;Data Source=.\SQLEXPRESS;User ID=sa;Password=●●●●●●●●;Initial Catalog=360plus;MaxPoolSize=1000 | |
//increase user connections SQL Server | |
//https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-user-connections-server-configuration-option | |
USE AdventureWorks2012 ; | |
GO | |
EXEC sp_configure 'show advanced options', 1; | |
GO | |
RECONFIGURE ; | |
GO | |
EXEC sp_configure 'user connections', 325 ; | |
GO | |
RECONFIGURE; | |
GO |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment