Long transactions causing sql timeouts

Tuesday, January 21, 2014
Avatar
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
Tuesday, January 21, 2014
Avatar
re: brucecran 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

Tuesday, January 21, 2014
Avatar
re: brucecran Tuesday, January 21, 2014

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

Regards

Adam

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Tuesday, January 21, 2014
  • Last Reply: Tuesday, January 21, 2014
  • Replies: 2
  • Views: 1752