Two New Clouds, Two New Locations

Announcements, Monitoring No Responses »
Oct 232009

Yesterday BrowserMob launched monitoring services on two more clouds GoGrid and Rackspace. This allows users to monitor their websites from four different regions now: Washington, Dublin, San Francisco, and Dallas. We are very excited to have added two new clouds since it will giving customers the ability to see how their site loads from different parts of the country and different network paths.

If there is a region that you’d particularly like to see let us know since we plan on rolling out more locations over the next few months.

Permanent link to this post (93 words, estimated 22 secs reading time)
Posted by admin at 10:29 am

Real Costs of Website Outages

In the press No Responses »
Oct 192009

Often times website outages cost a company money, and depending on the type of website this can calculation can be simple or difficult. If an e-commerce website goes down for an hour one can simply use the normal volumes to calculate the cost, but for reservation systems this can be more complex. For instance, if an airlines reservation system goes down the real cost both lost bookings and the cost of call operators.

“Of course when the web goes down, people are going to turn to the call centre and that’s why we were for a brief period this morning getting swamped there,” said Richard Bartrem, WestJet’s vice-president of culture and communications. (via Calgary Herald)

This is a preview of Real Costs of Website Outages. Read the full post (223 words, estimated 54 secs reading time)
Posted by admin at 10:07 pm

SQL Queries to Analyze the Results

FAQ, Load Testing Tips No Responses »
Oct 062009

After running the load test customer’s often download the database and run queries to determine their sites performance. Here are some common SQL queries to get you started:

Analyze the avg, max, and min time for each step in a transaction:

SELECT step, COUNT(*), AVG(time_active), MAX(time_active), MIN(time_active)
FROM step GROUP BY step;

General query to look at loading of objects, may want to increase or decrease the count. Depends on the size of the test:

SELECT path, COUNT(*), avg(time_active), MIN(time_active), MAX(time_active) FROM object
GROUP BY path HAVING COUNT(*) > 100 ORDER BY avg(time_active) DESC;

Get error msg grouped by error, host, status:

SELECT err_msg, host, status_code, COUNT(*), AVG(time_active)
FROM object GROUP BY err_msg, host, status_code

Give a breakdown of a specific path over the duration of the test:

SELECT date_format(start_time, '%H:%i'), COUNT(*), avg(time_active),
MIN(time_active), MAX(time_active), avg(time_to_first_byte), MIN(time_to_first_byte),
MAX(time_to_first_byte) FROM object WHERE path = '/'
GROUP BY date_format(start_time, '%H:%i')
ORDER BY date_format(start_time, '%H:%i');
This is a preview of SQL Queries to Analyze the Results. Read the full post (123 words, estimated 30 secs reading time)
Posted by admin at 1:35 pm
© 2012 The BrowserMob Blog Suffusion theme by Sayontan Sinha