System.Data.SqlClient.SqlException: Timeout expired.

kyle · Post by **kyle** » Mon Dec 10, 2007 9:33 am

Hello!

We are using Vault 3.5.1 (I know... we need to upgrade). I took over admin duties for our installation, and that is very high on my list to do.

We are following all of the recommended maintenance steps from your knowledgebase ( http://support.sourcegear.com/viewtopic ... bb5f76c50c ), but are having very bad performance problems. Hardware has been checked out and is running in good shape.

Below is an example of one failure while trying to check in a file. Any ideas what could be wrong, or where to look next?

sgvault.log
----12/10/2007 9:18:49 AM Kyler--krdevxp2.internetrti.com(192.168.0.173)--SSL Disabled System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.LockCheckoutList(VaultSqlConn conn, Int32 nRepID) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.LockCheckoutList(VaultSqlConn conn, Int32 nRepID)
----12/10/2007 9:18:49 AM Kyler--krdevxp2.internetrti.com(192.168.0.173)--SSL Disabled SQL transaction 286 successfully rolled back.
----12/10/2007 9:18:49 AM Kyler--krdevxp2.internetrti.com(192.168.0.173)--SSL Disabled FailDBFault
----12/10/2007 9:18:52 AM admin--vault.internetrti.com(192.168.0.73)--SSL Disabled Logout
----12/10/2007 9:18:52 AM admin--vault.internetrti.com(192.168.0.73)--SSL Disabled Beginning SQL transaction 358
----12/10/2007 9:18:52 AM admin--vault.internetrti.com(192.168.0.73)--SSL Disabled Beginning SQL transaction 357
----12/10/2007 9:18:52 AM admin--vault.internetrti.com(192.168.0.73)--SSL Disabled SQL transaction 357 successfully committed.
----12/10/2007 9:18:52 AM admin--vault.internetrti.com(192.168.0.73)--SSL Disabled SQL transaction 358 successfully committed.

lbauer · Post by **lbauer** » Mon Dec 10, 2007 10:59 am

The first thing you can try is increasing the SQLcommandtimeout value in the Vault.config file in the Vault Service directory. The default value is 3600 or 7200.