Load Testing a WordPress site

Hi guys, in this blog I am going to cover how to load test a web application. In this case its a wordpress application residing on my local server. You can also set up wordpress locally by downloading it from http://wordpress.org.

So we must start our load test.

1. Open visual studio and add a new Test project.
   
   
2. Right click your test project to add a new webtest

     

3.  Adding a webtest will launch you a browser with a record panel. In this case I am simulating a login process to a wordpress site .
    
      
   The record panel record all your browsing activites. Note that the recorder uses the url to record your action. If you have ajax or other script that doesnt changes the url then you need to manually code the test. Run your webtest once to check if it is getting pass. 
    
4. Next step would be to add a new load test. Right click the test project to add a new load test.
5. Go through the load test wizard and add your webtest to the load test.




6. You can specify the number of virtual users in the load pattern tab. There are 2 ways to add virtual user. 1 is the constant load other is the step up load. Constant load can be used when you really want to smoke up your server and test how many concurrent user it can handle and for how long.In our case we would be using the step up load. This load pattern simulates a ‘n’ number of user initially and Ramp up the users according to the values provided. You can also specify the duration you want to run your test for.
   
7. Run your load test and analyze the graphs. You can also save your load test report to the SQL server and then using SQL Server reporting services you can generate your own reports. To know how to save the load test reports to SQL Server view my other blog by clicking here

How to save Load Test reports in SQL Server

Hey Guys, recently I was working on Load Test automation using VS. By default VS stores all your Load Test report in SQLExpress but I wanted to have them stored on SQL Server. I digged hard and found out that following some simple steps it can be attained. I thought of sharing the same idea with you guys so that you dont have to dig in that hard.

So here we go..

Open the VS command prompt and type

cd n:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE.

dont forget to replace n: with the drive where your Visual Studio folder resides.

Once you are into that folder you need to type

SQLCMD /S localhost -i loadtestresultsrepository.sql

“loadtestresultsrepository.sql” contains all the sql scripts that create the “LoadTest” DB and another 24 tables in your sql server.

You also need to give credentials to connect to your DBserver( which in this case is localhost), you can give it using the following syntax

SQLCMD /S localhost -U <user name> -P <password> -i loadtestresultsrepository.sql

Once done with the above steps Click “Administer Test Controllers” under the “Test” Menu.

Click the browse button(…) to select the “LoadTest” DB.

You are now ready to run your Load Test and use your SQLServer Reporting Services to generate custom report.

Happy Testing

Danish Khan

Ramp Technology