This is a migrated thread and some comments may be shown as answers.

Load test - database issue

3 Answers 120 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Dan Ware
Top achievements
Rank 1
Dan Ware asked on 16 Nov 2012, 12:24 PM
I am trying to run a very basic load test using the trial version of Test Studio.  I am using the stand-alone version on Windows XP.

When I tried to run it with a maximum of 20 users it crashed with an "out of memory" exception so I reduced this number to 10.

When I run the load test, it happily moves to the "Analyze your results" window with no results available.  The three "lights" next to environment randomly turn red but the test never completes.  There is nothing in the event log to indicate any errors.

Eventually the "stop" button is enabled but the three lights continue to change between red and green until I restart the services.

When I check the database in SQL Management Studio, I notice that it created TestStudioReportingDB but there are no tables (or any other objects).

I have added the NT AUTHORITY\SYSTEM login to all of the admin server roles when I installed Test Studio (I believe it prompted me to ensure that login has adequate permission).

Do you have an idea what my problem might be?

EDIT: The log has lots of entries like "Invalid object name dbo.Results" indicating that the tables have not been created.  I want to change the user to SQL authenticated sa user - where can I reconfigure my connection?

EDIT 2: The exact same thing happens with the "sa" user in mixed authentication mode.  No tables!!

3 Answers, 1 is accepted

Sort by
0
Boyan Boev
Telerik team
answered on 19 Nov 2012, 09:15 AM
Hi Dan,

Thank you trying Test Studio. 

You can reconfigure your database connection from your start menu: Start > All Programs > Telerik > Test Execution > Configure Load Test Services. Please read more about it here.

In order to help you best please provide some detailed information:

1. Which version of SQL server you are using? If it is SQL server 2012 you should download our latest internal build (2012.2.1022), only this version is compatible with SQL server 2012. You can download it by logging in to your Telerik.com account and go to the Latest Internal Builds section

2. Please confirm that before the execution of the test you have configured your test environment correctly (All three lights are green), according to this article.
 
3. Can you please watch the memory use as the test runs using Task Manager? How does that look to you? Another option will be if you try to run your test on a different machine and see how this is working for you. 

4. Please send us your hardware configuration.

Please test the suggested approach and let me know if it helps

Kind regards,
Boyan Boev
the Telerik team
Are you enjoying Test Studio? We’d appreciate your vote in the ATI automation awards.
Vote now
0
Dan Ware
Top achievements
Rank 1
answered on 19 Nov 2012, 09:32 AM
Thanks for the reply!  I am very impressed with the software but this issue is stopping me from performing a load test.

I have tried SQL Server Express Edition 2005 (9.0.3042) on my local machine and SQL Server Developer Edition 2005 (9.0.4035) on another server.  With the "sa" user credentials or Windows authentication, the same thing happens on both SQL Server instances - the database gets created and then the Telerik error log fills up with "object not found" exceptions for the tables (which do not get created).

At this point one of the three green lights (reporter) flashes between green and red.

The only thing that I could think of, was that this is a permissions issue - but I have provided credentials of users with all permissions.

My development machine is Windows XP 32-bit with 4GB RAM and Core2 Duo 2.53GHz, I am using Telerik Test Studio (I have not tried the VS plug-in) and SQL Management Studio (2005).

I do not get any more memory exceptions since switching the number of users to ten, but still no database tables.  If I delete the database it gets created again when I run the test, but it doesn't handle the "no tables" error very well (it will just log the error continuously).
0
Boyan Boev
Telerik team
answered on 19 Nov 2012, 10:17 AM
Hello Dan,

I am afraid we do not support SQL server 2005. Please upgrade it to 2008 for example. If you want to upgrade it to 2012, please note that you should download our latest internal build as I mentioned  in the last answer.
 
Let me know if this helps.

All the best,

Boyan Boev
the Telerik team
Are you enjoying Test Studio? We’d appreciate your vote in the ATI automation awards.
Vote now
Tags
General Discussions
Asked by
Dan Ware
Top achievements
Rank 1
Answers by
Boyan Boev
Telerik team
Dan Ware
Top achievements
Rank 1
Share this question
or