Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save daltonnyx/9b28d1d4b4f1f6c1a068b659fd18c3a8 to your computer and use it in GitHub Desktop.
Save daltonnyx/9b28d1d4b4f1f6c1a068b659fd18c3a8 to your computer and use it in GitHub Desktop.
//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