Inflectra Customer Forums: Long transactions causing sql timeouts (Thread) We're running SpiraTest 3.2 (016), and have been getting reports (and logged events) of sql timeouts - sometimes a user is unable to use Spira for quite a while because of repeated timeouts; I saw one today, while at other times it was taking over a minute to display test sets. Looking at the Activity Monitor in SQL Server 2008 R2, there was a LCK_M_S wait on an UPDATE command. Is this something that has been improved in newer versions, or is there something I can change in SQL Server to improve things? en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/806.aspxthreadId=806Bruce Cran (bcran@fusionio.com)Long transactions causing sql timeouts We're running SpiraTest 3.2 (016), and have been getting reports (and logged events) of sql timeouts - sometimes a user is unable to use Spira for quite a while because of repeated timeouts; I saw one today, while at other times it was taking over a minute to display test sets. Looking at the Activity Monitor in SQL Server 2008 R2, there was a LCK_M_S wait on an UPDATE command. Is this something that has been improved in newer versions, or is there something I can change in SQL Server to improve things? Tue, 21 Jan 2014 19:27:06 -05002014-01-21T21:08:09-05:00/Support/Forum/spiratest/issues-questions/806.aspxmessageId=1473David J (support1@inflectra.com) Hi Bruce We did make large improvements in v4.0 and additional ones have been made in v4.1 ( Hi Bruce We did make large improvements in v4.0 and additional ones have been made in v4.1 (released at the end of the month). So you might want to schedule an upgrade. Regards Adam Tue, 21 Jan 2014 21:07:22 -05002014-01-21T21:07:22-05:00/Support/Forum/spiratest/issues-questions/806.aspx#reply1473messageId=1474David J (support1@inflectra.com) Also a refresh of the database indexes would probably be a good idea. Regards Adam Also a refresh of the database indexes would probably be a good idea. Regards Adam Tue, 21 Jan 2014 21:08:09 -05002014-01-21T21:08:09-05:00/Support/Forum/spiratest/issues-questions/806.aspx#reply1474