RT response time

Visit us on:

This email is subject to:

Torsten_Brumm · December 7, 2009, 8:17pm

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

Visit us on:

This email is subject to:

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

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

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

Matthew_Seaman · December 8, 2009, 6:52am

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 mod_log_config - Apache HTTP Server Version 2.2)

%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 · December 8, 2009, 7:00am

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 mod_log_config - Apache HTTP Server Version 2.2)

%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)

Torsten_Brumm · December 8, 2009, 7:23am

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:

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

Visit us on:

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

Torsten_Brumm · December 8, 2009, 7:25am

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

Visit us on:

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)

Raed_El-Hames · December 8, 2009, 10:53am

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

Visit us on:

This email is subject to: