Thread

Skip Navigation LinksForums > SpiraTest Forums > SpiraTest Issues & Questi... > Long transactions causing...

Long transactions causing sql timeouts RSS Feed

Tuesday, January 21, 2014
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?
2 Replies
Adam SAdam S
re: Bruce Cran on Tuesday, January 21, 2014
Tuesday, January 21, 2014

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

Adam SAdam S
re: Bruce Cran on Tuesday, January 21, 2014
Tuesday, January 21, 2014

Also a refresh of the database indexes would probably be a good idea.

Regards

Adam

Tagged
Statistics
  • Started: 1/21/2014
  • Last Reply: 1/21/2014
  • Replies: 2
  • Views: 407
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.