Long transactions causing sql timeouts

Tuesday, January 21, 2014 7:27:06 PM
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 9:07:22 PM
Avatar
re: brucecran on Tuesday, January 21, 2014 7:27:06 PM

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 9:08:09 PM
Avatar
re: brucecran on Tuesday, January 21, 2014 7:27:06 PM

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

Regards

Adam

Statistics
  • Started: Tuesday, January 21, 2014 7:27:06 PM
  • Last Reply: Tuesday, January 21, 2014 9:08:09 PM
  • Replies: 2
  • Views: 530