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

Long transactions causing sql timeouts

Tuesday, January 21, 2014

timeout

brucecran

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

inflectra.david

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

inflectra.david

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: 1935

Long transactions causing sql timeouts

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

Edit Thread

Edit Message

Search Results