10-07-2011 11:40 AM - edited 10-07-2011 12:06 PM
I have automated loadrunner to monitor each hour a website and create html reports of the tests.
Now I'd like to save the results on a database and I was wondering what were my options.
I really doubt highly such a thing is possible but I was wondering if it was possible to modify the vuser script to directly take the data collected when it is running and save it in a database.
I'd also like to know if, aside HTML, Word Document and Crystal Reports, there are anhy other possibilities for saving the analysis reports.
Right now, the option I'm thinking of is saving the results in a file with loadrunner controller or in a html report and parse the data in the file then save them into a database.
Solved! Go to Solution.
10-07-2011 12:51 PM - edited 10-07-2011 12:52 PM
I found out that Controller has the option of saving in text files.
Is it possible to save the data in a custom text file? for instance in a CSV file format. Because I would like to periodically import the data into a SQL Server using SQL server integration services.
10-08-2011 02:37 PM
It's entirely possible to have a script connect to a database and write all sorts of things. Just google 'mysql loadrunner'.
You might want to review your requirements though, are you trying to simply monitor a site to see how it performs over time? Is this a script to monitor a live system? There are far, far better (and easier) ways to do stuff like this than use a load testing framework.
10-11-2011 05:36 AM
The problem is, I must use a msSQL db. Does it only support connection on MySQL?
Yeah, I wasn't the one who chose to use Loadrunner as a tool for testing the website. Basically I'm pretty much stuck with it and I've got to deal with that... When I first was first told about how test were done, I did think that loadtunner wasn't designed to do this.
Just by curiosity, what would you recommend me to use for monitoring a website?
10-11-2011 12:36 PM
No, doesn't have to be mySQL, but why not? It's free and works.
Tools to monitor websites? I would guess that this is perhaps one of the most prolific types of software there is! There are so many tools to do this it's ridiculous. You've got free ones, epensive ones, SaaS ones, custom ones, quick ones, simple ones, advanced ones, integrated ones...far too many to name. If you are using LR to do this then I would suggest one of the quick, simple tools will more than meet your needs, You could find the worst, most rubbish monitoring tool on the market and it would be better than using LoadRunner!
Note. One tool (I forget which one it is) uses VUGen scripts, so if you already have these setup then that's a pretty nice bonus. It'll be one of the HP offerings.