SCORE - performance analysis tool now available

[Neil Warnock]

Dear All,

 

As previewed at the recent UKIUA I’m pleased to announce the availability of SCORE, an OpenROAD Server performance analysis tool which tracks the performance of individual SCP calls.  It has been released as an Open Source Project on the Community Wiki.

 

There are two parts to it;

 

1)      An image that you include in your system – this requires no code changes and can be left in situ; it is switched on and off to do statistics capture whenever you need it;

2)      A stats DB load script and graphical analysis tool. We’ve provided some performance charts and traffic lights etc in Excel to get you started but you might want to do your own analysis and reporting using Jasper, ad hoc SQL scripts or whatever.

 

There are detailed PDF user guides for both of the above.

 

If you currently use, or ever intend to use OpenROAD Server I’d recommend you take a quick look through the user guides at least.  SCORE reveals more precisely than ever before, just when and where your performance bottlenecks are occurring, or might occur in future.

 

http://community.ingres.com/wiki/SCORE_Home

 

Any questions, just shout.

 

Neil Warnock
Luminary - An Ingres Company
Tel: +44 (0) 845 371 4090
Mob: +44 (0) 7712 650291
Email: Neil.W...@luminary.co.uk

 

For more information on Luminary go to http://www.luminary.co.uk
Luminary Solutions Limited Registered in England No 4854134 VAT Reg No. 829 3166 13
Registered Office: Lacon House, Theobald's Road, London, WC1X 8RW

[Robert Allely]

Neil,

 

Is this going to work if the OpenROAD server runs on unix?

 

Robert Allely

Ports of Auckland NZ

---

From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Neil Warnock
Sent: Thursday, 16 July 2009 1:29 a.m.
To: openroa...@googlegroups.com; openroad-...@lists.ingres.com
Subject: [openroad-users] SCORE - performance analysis tool now available

Confidentiality/Privilege Notice:
This communication is confidential and may be legally privileged.  If you are not the intended recipient please delete the message and notify the sender at Ports of Auckland Limited. Any use, disclosure, copying, distribution or retention of this communication is strictly prohibited.

[Neil Warnock]

Hi Robert,

It's not been tested on Linux or unix but I don't see any reason why it won't work. I'd recommend recompiling the image file first using your unix installation.

Regards

Neil    

Sent from my iPhone

[James Higson]

Hi Neil,

 

I have followed your ‘quick start’ instructions and all has gone well.  The instructions suggest that the process will automatically write out the results after 1 hour (using defaults), but I am not getting any output in my C:\Temp directory after 8 hours.  The other option you mention is to ‘manually stop the OpenROAD server’.  I am sure this is a stupid question, but the only way I know to stop the OpenROAD server is to stop the service.  Is this what you mean?

 

Is there a way to get any visual queues that the SCORE logic is even being executed?  I know I should read the full user manual, and I will (eventually), but I am learning from my 18 year old son and am looking for a quick answer.

 

I don’t suppose the source code is available.  I assume it is 3gl.

 

Thanks chief,

 

James Higson

Melbourne, Australia

 

From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Neil Warnock
Sent: Wednesday, 15 July 2009 23:29
To: openroa...@googlegroups.com; openroad-...@lists.ingres.com
Subject: [openroad-users] SCORE - performance analysis tool now available

 

Dear All,

 

As previewed at the recent UKIUA I’m pleased to announce the availability of SCORE, an OpenROAD Server performance analysis tool which tracks the performance of individual SCP calls.  It has been released as an Open Source Project on the Community Wiki.

 

There are two parts to it;

 

1)      An image that you include in your system – this requires no code changes and can be left in situ; it is switched on and off to do statistics capture whenever you need it;

2)      A stats DB load script and graphical analysis tool. We’ve provided some performance charts and traffic lights etc in Excel to get you started but you might want to do your own analysis and reporting using Jasper, ad hoc SQL scripts or whatever.

 

There are detailed PDF user guides for both of the above.

 

If you currently use, or ever intend to use OpenROAD Server I’d recommend you take a quick look through the user guides at least.  SCORE reveals more precisely than ever before, just when and where your performance bottlenecks are occurring, or might occur in future.

 

http://community.ingres.com/wiki/SCORE_Home

 

Any questions, just shout.

 

Neil Warnock
Luminary - An Ingres Company
Tel: +44 (0) 845 371 4090
Mob: +44 (0) 7712 650291
Email: Neil.W...@luminary.co.uk

 

For more information on Luminary go to http://www.luminary.co.uk
Luminary Solutions Limited Registered in England No 4854134 VAT Reg No. 829 3166 13
Registered Office: Lacon House, Theobald's Road, London, WC1X 8RW

 

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

Specialist providers of back and front office systems for the financial services industry.
Featuring: Fintechnix(r)
Disclaimer:
Notice: This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action in reliance on it.
Any views expressed in this message are those of the individual sender,except where the sender specifically states them to be the views of Fintechnix Pty Ltd.

[Neil Warnock]

Hi James ,

By default it is turned off. You need to turn it on via the config file, which in turn should be referenced in the startup flags. 

There are other control params in that file too , such as write-to-file frequency. Whilst experimenting you could set that to a low number (eg 10 calls or a few minutes)  As you say, stopping the service should give a clean shutdown which will force a write-to-file.

Another thing that might be going wrong - Are you using GSCPs? Ie are you generating cover procs when you build the app? (checkbox needs to be checked). If you cant use gscps, you can mod your scps to include a call to the stats collector Maybe the doc needs to be clearer on that one. 

I suspect it's just not switched on. We chose that as a failsafe to avoid accidentally bursting disks etc. The idea it to build it into every app and leave in situ in case it is required in furure  By default it turns off after an hr too.

It's all 4GL and the code can be downloaded.  

Neil   

Sent from my iPhone

[James Higson]

Hi Neil,

 

I tried all sorts of combinations of config values with no success.  I then added trace messages to the ASO starting ghost frame to output the values of the config values to prove they were being picked up, and now it is working.  The wonders of OpenROAD!!  Is there a 'random results' generator somewhere in the 3gl that causes OpenROAD to behave differently with each image build?

 

Anyway, I won't complain about success.

 

Where can I download the source code?

 

Regards,

James

 

---

James Higson

Software Architect
Fintechnix

Lvl 3, 55 Clarence Street,

Sydney

Phone: +61 2 8235 8200

---

From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Neil Warnock

Sent: Friday, 17 July 2009 6:32 PM
To: openroa...@googlegroups.com
Subject: [openroad-users] Re: SCORE - performance analysis tool now available

[Bodo Bergmann]

Hi Neil,

 

I have found no information on the wiki or in the PDF doc (or your announcement) that it only works with GSCPs.

Therefore I thought you’ve found some clever 3GL hook into the SCP call (but was not sure how you can then GPL it).

If this is not the case and it means “SCORE does not work for regular 4GL procedures”,

then the doc  should definitely be updated and give information about how to (optionally) use the stats collector.

 

Bodo.

 

Bodo Bergmann | Sr. Software Engineer | Bodo.B...@ingres.com | Ingres Germany GmbH | Ohmstr. 12 | 63225 Langen | GERMANY | +49 6103 9881 0

 

From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Neil Warnock

Sent: Friday, July 17, 2009 10:32 AM
To: openroa...@googlegroups.com

[Neil Warnock]

Thanks Bodo. I think GSCPs get mentioned in the doc but obviously it's not clear enough so will amend. Also we will document the three proc calls you need to make if you are instrumenting normal 4gl procs exposed as scps. 

Finally (this is to James in particular) the 4gl exportapp didn't get copied into the downloads area. So much for 'open' source! Sorry. We'll rectify that too.

Rgds

Neil Warnock  

Sent from my iPhone

[Bodo Bergmann]

Neil,

 

I checked again,

GSCPS are mentioned nowhere in the doc – at least not on the Wiki (http://community.ingres.com/wiki/SCORE_Documentation)

or the PDF that could be downloaded from there (http://community.ingres.com/w/files/a/a7/SCORE_Data_Collector_User_guide.pdf).

 

Interesting is also that the downloadable files (on http://community.ingres.com/wiki/SCORE_Downloads) have a creation date in the future (29-Jul-2009).

It’s always good to be ahead of your time J

 

Best regards,

Bodo.

[Neil Warnock]

Hi Bodo,

 

Alex and Steve have updated the documentation and put the source code in the download.

 

http://community.ingres.com/wiki/SCORE_Home

 

Regards,

 

Neil Warnock
Luminary - An Ingres Company
Tel: +44 (0) 845 371 4090
Mob: +44 (0) 7712 650291
Email: Neil.W...@luminary.co.uk

 

For more information on Luminary go to http://www.luminary.co.uk
Luminary Solutions Limited Registered in England No 4854134 VAT Reg No. 829 3166 13
Registered Office: Lacon House, Theobald's Road, London, WC1X 8RW