Hi,
I have some questions around access to and maintenance of the Scheduled data in the DB.
We have been getting a lot of communication dropped error messages in the Test List log at the point of Publishing The Results after a big Test List run has completed. Firstly I didn't understand exactly where it was "Publishing?", "What?" and "To?". So I cleaned up all the Results folders on the execution/scheduled server ( currently the same machine ) and found that wasn't the case. I then thought about the DB which gets created when you first configure a Scheduled Server and found the tables which contains the data which gets displayed in the Run Results Viewer. I then found that in just a few weeks of running Test Lists, the dbo.test_result_d_b sits at 750,000 rows and is currently 5GB in size. I believe this is causing crashes when trying to synch results to the server and in turn we on occasion have had to reboot the scheduling server to get it up and running again as a result of this
- Is there a way to delete this data via the Test Studio UI?
- Should we be running some kind of maintenance jobs on here to purge this data?
- Also is it possible to delete all the data from the dbo.run_result_d_b table rather than via the Test Studio UI or at least A Select All as sometimes deleting all data is required and taking an absolute age to do it 1 page at a time!! Currently even once per week we can have a build up of 30 - 50 test lists per day which results in 30 odd pages to go through.
I appreciate any thoughts and help regarding this.
Thanks
Shane