Completed
Last Updated: 30 Nov 2015 07:55 by ADMIN
ADMIN
Cody
Created on: 16 Apr 2014 14:39
Type: Bug Report
18
The larger the SQL DB grows, the longer it takes for tests to start executing.
As more and more results are added to the storage service, it seems to significantly impact how long it takes for tests to start executing on a remote execution server. Once customer reports that in the beginning it took 5-7 minutes for execution to begin. After their DB file grew to 5GB, it now takes 20-25 minutes for execution to start. The size of the project did not change. It took them only one day of doing nothing but running multiple test lists to see this behavior.
15 comments
ADMIN
Daniel Djambov
Posted on: 30 Nov 2015 07:55
Telerik: this issue is no longer valid with latest Test Studio releases 2015.3 in which we changed the DB to MongoDB and implemented fixes for database optimization
Adrian
Posted on: 21 May 2015 09:53
When will this tool be part of a released version of Telerik Test Studio? 
Would it also be able to list all project Results and allow a user to Delete these Results - rather than using the script?
Would also be handy if you could resize the window. 
mike
Posted on: 30 Mar 2015 14:59
Ah, it's working now!  Thanks!
Cody
Posted on: 30 Mar 2015 14:52
Which link? This one: http://www.screencast.com/t/93auRz8D0 ? I just tested it and verified it's working normally here. Maybe there was a temporary problem with Screencast.com, or your IT department has blocked Screencast in your firewall.
mike
Posted on: 30 Mar 2015 14:43
Tried clicking on that screen cast link and got a 404 error.
Cody
Posted on: 20 Mar 2015 14:09
We have created a new small utility for managing projects and files stored in the SQL data base of the Telerik Storage Service. This utility can be downloaded from this link: http://docs.telerik.com/teststudio/dbbrowser/dbbrowser.zip. There is no installer for this small utility. Simply unzip the two files contained in the .zip file and place them in any folder of your choosing. Then run "TestStudioStorageDBBrowser". A video on how to use this utility can be viewed here: http://www.screencast.com/t/93auRz8D0.
Cody
Posted on: 20 Mar 2015 14:04
@mdichiser, Please create a new support ticket on your problem. Technical Support will be better able to assist you with your problem using that channel. We look forward to working with you on this.
mike
Posted on: 17 Mar 2015 20:59
I can see the SQLEXPRESS Server Name, but not able to see the TestStudioStorage DB
mike
Posted on: 17 Mar 2015 20:43
Where is the configuration for the SQL DB?  I have SQL Server Mgmt installed, but not seeing the TestStudioStorage DB.
Cody
Posted on: 17 Mar 2015 13:39
The easiest, and free method is to download and install Microsoft SQL Server Management Studio Express from this link:
http://www.microsoft.com/en-us/download/details.aspx?id=8961
mike
Posted on: 16 Mar 2015 19:53
What is the best way to connect to TestStudioStorage SQL Database to execute the SQL statements mentioned in the above link?
ADMIN
Boyan Boev
Posted on: 16 Mar 2015 14:08
The link has been fixed. Please excuse us of the inconvenience.
mike
Posted on: 16 Mar 2015 13:39
Server Error in '/teststudio' Application.

The resource cannot be found. 
ADMIN
Konstantin Petkov
Posted on: 25 Aug 2014 07:36
I'm posting a reference to the documentation for a work-around until this gets resolved:

http://docs.telerik.com/teststudio/user-guide/knowledge-base/scheduling/optimize_teststudiostorage.aspx
Milan
Posted on: 16 Apr 2014 15:06
This issue is a showstopper for our organization. We'd appreciate if someone can expedite the process and resolve this issue as soon as possible.