How can I safely purge a large amount of test runs?
Question ID: 108163

Hello. We would like to find out the best practice for purging test runs from Quality Center. The option to purge from TestLab causes the machine to go unresponsive considering the number of runs. 243,000 automated test runs to be exact. Is it a good idea to run a DELETE query on the SQL DB directly to delete all older runs?

Marked as spam
Posted by (Questions: 239, Answers: 31)
Asked on February 2, 2018 4:55 pm
Answers (1)
Private answer

Hello. Manual modification within the ALM database tables is not recommended or supported by MF, as this may impact the projects functionality. Since you have so many test runs to delete, I would like to suggest the following utility to delete the old test runs from ALM. The Stand Alone ALM Purge Utility should be able to successfully delete the old test runs without sacrificing machine performance. The following link will take you to a knowledge document where the utility can be downloaded. The knowledge document also contains information on how to use the utility. Before using the tool, be sure to make a backup copy of the project you wish to use the tool on, in the case of any unforeseen issue occurs. I hope this helps!

[Link to the Stand-Alone ALM Purge Utility][1]


Marked as spam
Posted by (Questions: 2, Answers: 300)
Answered on February 2, 2018 4:57 pm

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top