Uncategorized

excel :: displaying vugen response times

I use excel a lot, most performance testers will. It’s powerful when teamed up with funky macros, and can make life easier. It wasn’t always this way.
I feared excel (mainly because i was a n00b using it) but inspiration from my VB developer / performance tester extraordinaire / senior (read:old man) – Gary Cassar, I’ve learnt to embrace the warmth and fuzziness that lies within excel and use it to my advantage. I’ve written a few macros, not amazing, but I’ve been able to get some great results.

One bugbear that I have, is when I copy summary data from HP analysis into Excel. What happens, is that it inserts a whole bunch of images where the “SLA” field is. This screws up the formatting when pasting into word for a funky looking TSR. I used to delete them manually, until old man Gary blasted this out from across the room.
read more »

Uncategorized

vugen :: run a remote shell script – cmd

Greetings,
Today, I needed to reset IIS on a remote machine as part of my vuser init. Why you ask? Well, every time I start a test, I have to do this manually. You know my motto – “if it needs to be completed more than once, automate!”. Lazy? yes, but thats how I roll. In order to do this, you need to run PSEXEC. Google it, download it, and put it somewhere safe.
read more »

Uncategorized

vugen :: split a string

Another little C function that I find helps me from day to day, which I’ve rewritten about 10 times and never saved, so here it is.
Its pretty basic, but handy. So lets say you have a string…”10/11/2013″ and you want to ‘re-jig’ it to 2013/11/10. There’s a few ways to do it with C string functions, but it all gets a little messy and ugly.
read more »

Uncategorized

ruby :: scan log file and print matching output

Lately, I’ve wanted to scan some vugen log files for errors, so I can correlate vuser errors with application errors.
This has been fairly easy to do as I suffix all my error capturing code in vugen with ###, so I just search for that.
However, when your log files are 500,000 lines long, and your error count gets high, its pretty annoying to hit F3 every time, luckily, ruby is yet again to our service. read more »

Uncategorized

excel :: datapools :: finding duplicates

So, have you ever been a situation, where you have 55 scripts, 5,000 virtual users, and the applicatoin MUST have unique login’s ? Wow! me too.
It poses an intersting situation. Once you kick off your scripts, you are riddled with errors, as users are logging other users out, and stepping on everyone else’s toes. Managing datapools can be tricky, ther are many solutions like virtual tables, or using a mysql db to log which users are logged in, but for the real real dirty, script and turf, nothing beats a good datapool. So how do you manage 5,000 users, and ensure none of them are duplicated accross script groups. Easy!
read more »

Uncategorized

vugen :: search and replace characters in a string

What happens when you have to submit special charaters, or reserverd characters in vugen? It can be quite a pain. Yes you can always do a web_convert_param(), but sometimes it doesnt do what you need. I’ve noticed it converts a space to a + not a %20….This has really confused me when submitting a webform…
The only other way to get around it is to write a function that searches your string, and replaces it.
read more »

Uncategorized

vugen :: send email [gmail] on error

Ever had to run a soak test, load test, whatever test at an un-Godly hour? Did you ever hit ‘play’ and then go home, and, just pray (religious?) that the test would be finished with all your results when you get to work the next day?, only to find it crashed 4 mins after you left…yes, it sucks.
In my situation, I had a script running for about 3 days. Don’t ask why, it was just the situation I was in…! I found myself logging into the box every few hours to make sure the script was running, and it was really getting on my nerves. It got to a point where I would spontaneously wake up in the middle of the night just to check it…yes, I’m a freak, thanks for coming to my show!.
So to get around this, I managed to create a very easy way to have vugen send you an email when your script fails. Its really quite simple.
read more »

Uncategorized

not having clause :: sql

A quick and dirty blog, cause I’m really busy.
This is simple sql for the guru’s (however, I’m not a guru!), but I recently had to find out how many records don’t exist in a table.
Its easy enough to find out how many do, using the magical count(*), but I’ve never had to do this…and if I did, it was probably a silly looking subquery.
read more »

Uncategorized

diffing scripts :: vugen

Working out how which values in a script need to be paramatised can be tedious and time consuming if completed manually. I always wonder about people who things manually, when, in this world of technology, we are able to utilise different applications, and tools to assist our day to day activities. Plus, its also damn boring. There’s a solution at hand, and if you are a half decent performance tester, you’ll know you need to record 2 of the same scripts and diff the changed content…if you don’t know this, I highly consider a career change.
read more »

Uncategorized

mysql gui database management

I very rarely blog about an application, however sometimes there is an app or two that make my life and job a lot easier to manager. I use a lot of mysql databases, and managing them is something I like to, lets say…not do.
I simply don’t like navigating through databases and tables from the mysql command line editor, and I really hate the PHP gui tool that it comes with…its just so cumbersome. I’ve been using navicat of late, but I hate the idea that I have to pay for it. I mean lets face it, why the heck would you want to pay for a tool that manages an open-source application! Its irony at its greatest. So in my early morning googling, I stumbled across a diamond among the db management tools.
read more »