ADO Database Connection Pool size

Different connection strings create different pools, Max pool size=200; Min Pool size=5 The maximum minimum value of the same connection string, and each connection string has its own maximum minimum value.

Max Pool Size default 100,min pool size default 0.

Https://msdn.microsoft.com/zh-cn/library/8xx3tyca (v=vs.80). aspx

Https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlconnection.connectionstring (vs.80). aspx

Pool creation and allocation

When the connection is first opened, a connection pool is created based on the exact matching algorithm that associates the pool with the connection string in the connection. Each connection pool is associated with a different connection string. When you open a new connection, a new pool is created if the connection string does not exactly match the existing pool. Pool connections are created by process, by application domain, by connection string, and by Windows identity (when using integrated security).

Timeout time has arrived. The time-out elapses before the operation completes or the server is not responding.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Http://www.dotnetspark.com/links/18280-timeout-when-calling-sqldataadapterfilldataset.aspx

Http://stackoverflow.com/questions/14993309/what-is-snireadsyncoverasync-and-why-would-it-take-a-long-time-to-complete

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.
The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (0x80004005): The pending operation is obsolete.
At System.Data.SqlClient.SqlInternalConnection.OnError (SqlException exception, Boolean breakconnection, Action ' 1 Wrapcloseinaction)
At System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning (Tdsparserstateobject stateobj, Boolean Callerhasconnectionlock, Boolean Asyncclose)
At System.Data.SqlClient.TdsParserStateObject.ReadSniError (tdsparserstateobject stateobj, UInt32 error)
At System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync ()
At System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket ()
At System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer ()
At System.Data.SqlClient.TdsParserStateObject.TryReadByte (byte& value)
At System.Data.SqlClient.TdsParser.TryRun (Runbehavior runbehavior, SqlCommand Cmdhandler, SqlDataReader DataStream, Bulkcopysimpleresultset Bulkcopyhandler, Tdsparserstateobject stateobj, boolean& dataReady)
At System.Data.SqlClient.SqlDataReader.TryConsumeMetaData ()
At System.Data.SqlClient.SqlDataReader.get_MetaData ()
At System.Data.SqlClient.SqlCommand.FinishExecuteReader (SqlDataReader ds, Runbehavior runbehavior, String resetoptionsstring)
At System.Data.SqlClient.SqlCommand.RunExecuteReaderTds (CommandBehavior cmdbehavior, Runbehavior Runbehavior, Boolean Returnstream, Boolean async, Int32 timeout, task& Task, Boolean asyncwrite, SqlDataReader DS)
At System.Data.SqlClient.SqlCommand.RunExecuteReader (CommandBehavior cmdbehavior, Runbehavior Runbehavior, Boolean Returnstream, String method, TaskCompletionSource ' 1 completion, Int32 timeout, task& Task, Boolean asyncwrite)
At System.Data.SqlClient.SqlCommand.RunExecuteReader (CommandBehavior cmdbehavior, Runbehavior Runbehavior, Boolean Returnstream, String method)
At System.Data.SqlClient.SqlCommand.ExecuteReader (CommandBehavior behavior, String method)
At System.Data.SqlClient.SqlCommand.ExecuteDbDataReader (CommandBehavior behavior)
At System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader (CommandBehavior behavior)
At System.Data.Common.DbDataAdapter.FillInternal (DataSet DataSet, datatable[] DataTables, Int32 Startrecord, Int32 MaxRecords, String srctable, IDbCommand command, CommandBehavior behavior)
At System.Data.Common.DbDataAdapter.Fill (DataSet DataSet, Int32 Startrecord, Int32 maxrecords, String srctable, IDbCommand command, CommandBehavior behavior)
At System.Data.Common.DbDataAdapter.Fill (DataSet dataset)
At DNA.OpenPlatform.Common.SqlHelper.ExecuteDataset (String connectionString, CommandType commandtype, string CommandText, Sqlparameter[] commandparameters)

ADO Database Connection Pool size