Tuesday, May 6, 2014

Red Samurai ADF Performance Audit Tool v 3.1 - Drill Down Analysis Improvements

We have new improvements in Red Samurai ADF Performance Audit tool. Update 3.1 is focused on new features in drill down reports for Slow Queries and Large Fetches.

Current day occurrences (in red) for Slow Queries are calculated per individual VO instance, along with latest occurrences (in yellow) and total occurrences. This helps to track outcome of performance fixes and understand if additional tuning is required for specific VO instance:


It is possible to select VO instance and display Weekly Trend - graph displaying distribution of reported Slow Queries per during previous days. This helps to understand, how reported issues were distributed recently and if tuning is producing any positive effect:


The same statistics are reported for Large Fetch issues in VO instances:


Weekly Trend is displayed for selected VO instance with Large Fetch:

6 comments:

Anonymous said...

Hi Andrejus,

Where can I download a evaluation copy of this perform Aud tool v 3.1?

Andrejus Baranovskis said...

There is no public download. You should send me email offline and describe your case. We are sharing this tool free of charge to existing or prospective customers.

Regards,
Andrejus

Siu Fai Ng said...

Hi Andrejus,

I encounter the following error when I perform stress test.

A request was timed out while waiting for a resource to be returned to the resource pool, InternalDCAMs.

I would like to know the purpose of InternalDCAM and how to overcome this problem.

Thanks.

Regards,
Tony

Andrejus Baranovskis said...

This would require debugging your application, could be many different reasons.

Andrejus

Siu Fai Ng said...

Thanks for your update.

I cannot find any information about InternalDCAM in ADF books or web sites. Do you have any reference link talking about InternalDCAM?

I really do not have any idea how to solve this problem. I guess the allocation of InternalDCAM should be growth and then released. This pattern occurs periodically.

Thanks a lot !

Tony

Andrejus Baranovskis said...

It is hard to give proper answer, without seeing and debugging your code. There could be many reasons, depending what components are used in code.

Andrejus