SQLServerCentral.com / SQL Server 2005 / Development / sqlmail timout connection pool / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 15:01:39 GMT20RE: sqlmail timout connection poolhttp://www.sqlservercentral.com/Forums/Topic1319427-145-1.aspx[quote][b]tjmoore99 (9/17/2012)[/b][hr]Did you ever find a solution for this? We are having a similar problem where we get this error around 9:00p.m. every night for some reason.[/quote]Yes it is fixed. I believe we increased the database Mail Executable Minimum Lifetime setting in the Database Mail System Parameters.Tue, 02 Oct 2012 14:11:29 GMTlwheelerRE: sqlmail timout connection poolhttp://www.sqlservercentral.com/Forums/Topic1319427-145-1.aspxset the trace for that particular time interval and see what other and related stuff is running ? and other thing try to see the perf mon too (i suspect there could be resource crunch too)Sun, 30 Sep 2012 11:15:50 GMTBhuvneshRE: sqlmail timout connection poolhttp://www.sqlservercentral.com/Forums/Topic1319427-145-1.aspxDid you ever find a solution for this? We are having a similar problem where we get this error around 9:00p.m. every night for some reason.Mon, 17 Sep 2012 11:30:24 GMTtjmoore99sqlmail timout connection poolhttp://www.sqlservercentral.com/Forums/Topic1319427-145-1.aspxI am using an SQL Job to call a stored procedure which queries the database to get some email addresses and creates an HTML body. The procedure then calls sp_send_dbmail to send the emails.I get an error on the job regarding a connection timeout. I'm not sure if the timeout is returning from the exchange server or the SQL server.Any ideas?Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseExceptionMessage: There was an error on the connection. Reason: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached., connection parameters: Server Name: , Database Name: msdbData: System.Collections.ListDictionaryInternalTargetSite: Void OpenConnection(Microsoft.SqlServer.Management.Common.SqlConnectionInfo)HelpLink: NULLSource: DatabaseMailEngineStackTrace Information=================== at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.OpenConnection(SqlConnectionInfo ci) at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.OpenConnection(String dbServerName, String dbName, String userName, String password) at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.ProcessQueueItems(String dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel loggingLevel)2) Exception Information===================Exception Type: System.InvalidOperationExceptionMessage: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.Data: System.Collections.ListDictionaryInternalTargetSite: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection)HelpLink: NULLSource: System.DataStackTrace Information=================== at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.OpenConnection(SqlConnectionInfo ci)Thu, 21 Jun 2012 09:56:03 GMTlwheeler