Importing load test results to Sql Azure

Introduction

 

Cloud Load Testing can be used for performance and load testing of your application by generating load from Azure. If you are new to Cloud Load Testing then the following links will help you:

For the folks who are familiar with load test would also know that the load test results are imported to a database.

 One of the frequent asks is to be able to import these results in a SQL Azure database in place of on-prem db.

This blog provides a step by step guide on how you can use Visual Studio 2013 Update 5 or Visual Studio 2015 to achieve this.

 

Step 1:  Creating LoadTest2010 DB in a SQL server and SQL Azure is slightly different. This step requires you to create a new database with LoadTest2010 schema in SQL Azure.

  1.           Please create a DB called LoadTest2010 in your Azure SQL Server. (Based on your run duration and ltrar size choose the web edition or business edition appropriately)
  2.           Once you have created a DB, please connect to the db and copy the contents of SQL file from this location (SQL File Location) and execute the statements. (Link to “How to manage SQL Azure“)

Step2: Once your DB is created, go to your load test project in Visual studio, Navigate from Load Test ->Manage Test Controllers:

 

 

 Update the Load test results store  to point to the SQL server you just created.

Something like this :

 

 

 

Click ok and close the Manage Test Controllers window.Your setup for importing results to SQL Azure is done.

Now, you can simply download the result from Load Test Manager window or from Load Test Results window .The results will be imported in your SQL Azure DB.

 

Things to keep in mind:

  1. If you SQL Azure DB and the machine you have VS ultimate installed are in two different regions, there will be latency in importing the results. It is preferable to keep the two in same data center.
  2. The size of your results is directly proportional to duration and counter instances reported for that run. Make sure that your load test DB on SQL Azure has sufficient space.
  3. Cloud Load Testing is currently in two DCs , East US and West Europe.

 

If you have a feature request for us or an improvement you’d like to see, please log them on our user voice site.