RT response time

Hi;

Versions 3.6.4 and 3.8.5
apache2,mod_perl2 and mysql5

Have anyone done any kind of monitoring / profiling of RT response time,
ie measure the time it takes to display a ticket / (or create a ticket
but possibly doing this every 5/10 minutes wont be desirable)
Can anyone recommend any software (preferably open source) that can do
that?

*Roy El-hames *

ISP Systems

Vialtus* Solutions*

Direct Dial: +44(0) 208 587 6181

E-mail: rfh@vialtus.com mailto:rfh@vialtus.com

Visit us on:

www.vialtus.com http://www.vialtus.com/

This email is subject to:

http://www.vialtus.com/disclaimer.html

Ho raed,
Some of my users created a vb scrip (fuckinbg crap) doing something like this. Sent it to you tomorrow!
Torsten

----- Originalnachricht -----Von: rt-users-bounces@lists.bestpractical.com rt-users-bounces@lists.bestpractical.com
An: RT Users rt-users@lists.bestpractical.com
Gesendet: Mon Dec 07 19:18:37 2009
Betreff: [rt-users] RT response time

Hi;

Versions 3.6.4 and 3.8.5
apache2,mod_perl2 and mysql5

Have anyone done any kind of monitoring / profiling of RT response time,
ie measure the time it takes to display a ticket / (or create a ticket
but possibly doing this every 5/10 minutes wont be desirable)
Can anyone recommend any software (preferably open source) that can do
that?

*Roy El-hames *

ISP Systems

Vialtus* Solutions*

Direct Dial: +44(0) 208 587 6181

E-mail: rfh@vialtus.com mailto:rfh@vialtus.com

Visit us on:

www.vialtus.com http://www.vialtus.com/

This email is subject to:

Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Raed El-Hames wrote:

Versions 3.6.4 and 3.8.5
apache2,mod_perl2 and mysql5

Have anyone done any kind of monitoring / profiling of RT response time,
ie measure the time it takes to display a ticket / (or create a ticket
but possibly doing this every 5/10 minutes wont be desirable)
Can anyone recommend any software (preferably open source) that can do
that?

If you modify the apache log format, you can get it to include the amount
of time it spends to serve each page. Something like this:

LogFormat “%h %l %u %t “%r” %>s %b “%{Referer}i” “%{User-Agent}i” %D”

(See http://httpd.apache.org/docs/2.2/mod/mod_log_config.html)

%D is the time in microseconds it takes to serve the request. There’s also
%T, but that’s measured in integer numbers of seconds, so it’s almost always
0 for any reasonably good web-server. %D is to some extent determined by
how fast the web clients can receive the data, but this should not be rate
limiting unless you have particularly old and slow client machines or people
accessing the site through dial-up connections.

AFAIK most weblog analysis software doesn’t deal with the time taken to serve
a request, because that data isn’t included in the standard log file formats.
However, writing a small perl script to calculate statistics for each of the
different queries (%r in the format) should be fairly trivial to do.

Cheers,

Matthew

Dr Matthew Seaman The Bunker, Ash Radar Station
PGP: 0x60AE908C on servers Marshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK

signature.asc (259 Bytes)

Matthew Seaman wrote:

Raed El-Hames wrote:

Versions 3.6.4 and 3.8.5
apache2,mod_perl2 and mysql5

Have anyone done any kind of monitoring / profiling of RT response
time, ie measure the time it takes to display a ticket / (or create a
ticket but possibly doing this every 5/10 minutes wont be desirable)
Can anyone recommend any software (preferably open source) that can do
that?

If you modify the apache log format, you can get it to include the amount
of time it spends to serve each page. Something like this:

LogFormat “%h %l %u %t “%r” %>s %b “%{Referer}i” “%{User-Agent}i” %D”

(See http://httpd.apache.org/docs/2.2/mod/mod_log_config.html)

%D is the time in microseconds it takes to serve the request. There’s also
%T, but that’s measured in integer numbers of seconds, so it’s almost
always
0 for any reasonably good web-server. %D is to some extent determined by
how fast the web clients can receive the data, but this should not be
rate limiting unless you have particularly old and slow client machines
or people accessing the site through dial-up connections.

AFAIK most weblog analysis software doesn’t deal with the time taken to
serve
a request, because that data isn’t included in the standard log file
formats.
However, writing a small perl script to calculate statistics for each of
the different queries (%r in the format) should be fairly trivial to do.

Another approach is to use the Firebug extension to Firefox – this
gives you a detailed breakdown of the time it takes to display a web
page (including all of the sub-requests for images etc.)

http://getfirebug.com/

Only shows you timings for one page at a time though, and needs to be
run interactively.

Cheers,

Matthew

Dr Matthew Seaman The Bunker, Ash Radar Station
PGP: 0x60AE908C on servers Marshborough Rd
Tel: +44 1304 814890 Sandwich
Fax: +44 1304 814899 Kent, CT13 0PL, UK

signature.asc (259 Bytes)

Hi Raed,
find attached vbs script. let me explain how it works.

It opens IE, logging in as user (credentials you find in password file) and opening the homepage, opening a queue and a ticket, then does a ticket update (comment) and returns back to homepage. this is done every few seconds from begining. All counted times are stored in a newly created xls file.

Pls have a closer look into the vbs, this is created for our setup, i think you have to change something:

Line 179:

'Erster Schritt: Start RT bis zum Login Schirm
RTloginURL=“http://ticket.int.kn/

Line 254:

.navigate(“http://ticket.int.kn/Search/Results.html?Order=ASC&Query=Queue%20%3D%20’PERFORMANCETEST’%20AND%20(Status%20%3D%20’open’%20OR%20Status%20%3D%20’new’%20OR%20Status%20%3D%20’stalled’%20OR%20Status%20%3D%20’pending’%20OR%20Status%20%3D%20’accepted’%20OR%20Status%20%3D%20’implement’%20OR%20Status%20%3D%20’approved’%20OR%20Status%20%3D%20’verified’%20OR%20Status%20%3D%20’waiting’%20OR%20Status%20%3D%20’testing’%20OR%20Status%20%3D%20’delivered’%20OR%20Status%20%3D%20’develop’)&Rows=&OrderBy=id&Page=1&Format=”)

Change this to your test queue

Line 275:

.navigate("http://ticket.int.kn/")

Line 296:

Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne

-----Urspruengliche Nachricht-----Von: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Im Auftrag von Raed El-Hames
Gesendet: Montag, 7. Dezember 2009 19:19
An: RT Users
Betreff: [rt-users] RT response time

Hi;

Versions 3.6.4 and 3.8.5
apache2,mod_perl2 and mysql5

Have anyone done any kind of monitoring / profiling of RT response time, ie measure the time it takes to display a ticket / (or create a ticket but possibly doing this every 5/10 minutes wont be desirable) Can anyone recommend any software (preferably open source) that can do that?

*Roy El-hames *

ISP Systems

Vialtus* Solutions*

Direct Dial: +44(0) 208 587 6181

E-mail: rfh@vialtus.com mailto:rfh@vialtus.com

Visit us on:

www.vialtus.com http://www.vialtus.com/

This email is subject to:

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Sorry, sent to early.

Line 296:

Writefile.write(ReturnEventString("before comment 1756115;")+vbCr+vbLf)
starttimer=Timer() 
.navigate("http://ticket.int.kn/Ticket/Update.html?Action=Comment&id=1756115")

Line 323:

.navigate("http://ticket.int.kn/NoAuth/Logout.html")

This line you should all edit to cover your RT Installation.

Find attached RT Pinger.zip.

PS: This is not the perfect test scrip, but it works well for us.

Torsten

Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne

-----Urspruengliche Nachricht-----Von: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Im Auftrag von Raed El-Hames
Gesendet: Montag, 7. Dezember 2009 19:19
An: RT Users
Betreff: [rt-users] RT response time

Hi;

Versions 3.6.4 and 3.8.5
apache2,mod_perl2 and mysql5

Have anyone done any kind of monitoring / profiling of RT response time, ie measure the time it takes to display a ticket / (or create a ticket but possibly doing this every 5/10 minutes wont be desirable) Can anyone recommend any software (preferably open source) that can do that?

*Roy El-hames *

ISP Systems

Vialtus* Solutions*

Direct Dial: +44(0) 208 587 6181

E-mail: rfh@vialtus.com mailto:rfh@vialtus.com

Visit us on:

www.vialtus.com http://www.vialtus.com/

This email is subject to:

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

RT Pinger.zip (5.78 KB)

Thanks Torsten, I know little about VB , but will give it a go …

*Roy El-hames *

ISP Systems

Vialtus* Solutions*

Direct Dial: +44(0) 208 587 6181

E-mail: rfh@vialtus.com mailto:rfh@vialtus.com

Visit us on:

www.vialtus.com http://www.vialtus.com/

This email is subject to:

Brumm, Torsten / Kuehne + Nagel / Ham MI-ID wrote:

Thanks Matthew,
I use Firebug during the development but for my purposes I would need
something robotic collecting and stating in the back ground, although
some its suggestions/recommendations is not always useful.
I have considered/ing the web logs, and using ‘rt_base_time’, but both
these are server responses (which logically should be all I need),
however the powers above me (and to a certain extent have a good point),
suggests that the server time is a fraction of the time it takes to
display a page and I have tested on a DualCore 2.6 GH with 2G ram
running windows xp no applications except using IE7 pulling an average
ticket with 9 updates -no attachments and few ticket custom fields , the
rt_base_time was ~ 1.5 seconds however it took around 8 seconds for the
page to display … This done few times at different time of the day, the
link between my client and the rt server is Gig link …

Does anyone else see this slowness?

Roy

Matthew Seaman wrote: