Developer forum

Forum » CMS - Standard features » SQL Connection timeout

SQL Connection timeout

E-mail notifications
Terri Donahue
Terri Donahue
Reply
Posted on 23/02/2021 12:42:49

Hi guys,

I need to increase the default sql connection timeout from 10 seconds to 30 seconds. I don't see a way to configure this in the globlsettings.aspx file. Is there a way to do this?


Replies

 
Nicolai Pedersen
Posted on 23/02/2021 12:50:44
Reply

That is not possible. 

You can use the connection string setting and construct the entire connectionstring (inlcuding username and password) to override the connection timeout (Connection Timeout=30).

You can change the command timeout using /GlobalSettings/System/Database/CommandTimeout - default is 30.

BR nicolai

 
Terri Donahue
Terri Donahue
Posted on 23/02/2021 19:31:13
Reply

Thanks Nicolai,

I took a memory dump and analyzed it this morning. Our client is running Dw 9.8.11 and there isn't anything that I am aware of that is setting the connection timeout, but it is definitely set to 10 seconds. I'll test in their dev environment updating the globalsettings file to see if I can override that value.

ADO.NET Connections Report

Connection Type MaxPoolSize Connection String Current Connection Count Connections Open
System.Data.SqlClient.SqlConnectionString 200 User Id=dbuser;Password=*****;Initial Catalog=databasename;Server=.;Min Pool Size = 5; Max Pool Size=200; 43 43
System.Data.SqlClient.SqlConnectionString 200 Server=.;Database=biolegend.com;User Id=dbuser;Password=*****;Min Pool Size = 1; Max Pool Size=200;Connection Timeout=10; 1 1
 
Nicolai Pedersen
Posted on 24/02/2021 08:21:51
Reply

It could be a custom ConnectionProvider which is a piece of code you can add to Dynamicweb.

 

You must be logged in to post in the forum