Thread

Skip Navigation LinksForums > SpiraTeam Forums > SpiraTeam Issues & Questi... > 3.2 performance vs previo...

3.2 performance vs previous versions? RSS Feed

Wednesday, February 8, 2012
Hi,
We have just upgraded to 3.2 (SpiraTeam) and have noticed significant performance hit.

We also upgraded the host, XP -> Server 2008 R2, SQLExpress -> SQL Server 2008 Full, 4GB -> 8GB.

Our live system went from 2.3.1 -> 3.2 in a single sweep, but we had also assessed 2.3.1 -> 3.1 in a test env, where the migration was error prone, and led to support tickets, but the performance was not as bad as 3.2 appears to be.  The 3.2 upgrade ran smoother and gave us much more confidence, especially as the 3.1 -> 3.2 could not be achieved in house, after our database became corrupted during migration.

Do you have any benchmark data for different versions or configurations?

Are there any known tweaks that might give us better performance?

Significant delays are now seen whenever large sets of data are manipulated (Show All Levels -> Show Level 1).

It might be worth pointing out that our SpiraTeam DB is approaching 4GB, which was the main reason for SQL upgrade.  Are there any known issues with this?

Thanks,
Charlie
2 Replies
Adam SAdam S
re: Charlie Stott on Wednesday, February 8, 2012
Friday, February 10, 2012

Can you check that the database transaction logs are not getting large (you may need to do a backup / truncate of the logs) and that the database indexes are current. The process of migration can cause the logs to get full and the indexes to get out of date (since it's doing a bunch of INSERTs to repopulate the database). This usually explains any post-upgrade performance issues. See https://www.inflectra.com/Support/FAQs.aspx#technical07 for how to refresh the indexes.

Andy SmithAndy Smith
re: Adam S on Friday, February 10, 2012
Monday, March 4, 2013
Hello Adam, we have a performance issue that appears not to be related to an upgrade - although we have recently upgraded to version 4.0 we had problems reported prior to this. The logs look OK and our database is only about 360 MB anyway. Our system administrator was going to re-build the indexes but the link on the previous post gives an error. Can you either fix the link or post the original content on this thread please. Thanks and regards. 
Tagged
Statistics
  • Started: 2/8/2012
  • Last Reply: 3/4/2013
  • Replies: 2
  • Views: 948
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.