Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Connection String Settings: Timeouts and Pooling

 

If you are having SQL Server Database connection issues, I reckon they could be due to one of two connection string issues. Note that the connection string timeout is the 15s by default, so in the string below I triple it, for example, to 45 second (or on could try 30s as an incremental step), and secondly, if you do not want pooling you have to explicitly state you so not want it, as so:
 
If you are using Windows Authentication, or Integrated Security in Connection string lingo, here’s an example that disables Pooling:
Server=<SQL Server Instance>;Connection Timeout=45;Integrated Security=SSPI;
Pooling=false
Or if are using SQL Server authentication:
Server=<SQL Server Instance>;Connection Timeout=45;uid=;pwd=;Pooling=false

There is also the dynamic system view sys.dm_exec_connections , but I am intentionally brief on this since fellow MVP Glenn Berry has done such a great job already and recently on this within his DMV a day series J

 

 

 

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.