This is a static archive of our old Q&A Site. Please post any new questions and answers at ask.wireshark.org.

Can Wireshark monitor database request and response times?

0

Hi All,

I have an application written in "Progress-4GL". It gets connected to Progress DB whenever a request is raised through the application. I want to do performance testing on this request response chain. Performance in the sense, if 10 users are accessing the DB then what will be the throughput. If the number of users is increased to 50 then what will be the throughput.

Can I do the the above performance testing using WireShark?

asked 14 Mar '13, 21:45

Jayanth's gravatar image

Jayanth
1111
accept rate: 0%


One Answer:

0

Sure, you can do that kind of testing with Wireshark. The only (small) problem is that I don't think Wireshark has decodes for Progress-4GL, so everything after the TCP layer will be more or less "unreadable". This means that you'll have to guess what the purpose of the packets are, if that is of any relevance in your test.

Usually you can try to do a time limited test of 10 users, having them all start at the same time doing something according to a test plan, and then go through all the statistics you need to see what happened. Conversation statistics, Summary statistics and I/O graph could be the most interesting ones. You could also test just one connection and base line that first, to see if it scales.

In my experience (I used to work for Progress Germany for a few years) most database transactions are pretty small when it comes to packet sizes, unless you're transferring huge tables worth of data in each connection. Database performance felt by the users is usually more depending on low latency connections than high bandwidth, so if I were you I'd also check how long certain user activities take to complete.

answered 15 Mar '13, 02:21

Jasper's gravatar image

Jasper ♦♦
23.8k551284
accept rate: 18%