I see many metrics collected from using xls (excel) files:
By Frontend|SpreadAnalysis|Backend Calls|\\s0134iffs01\spreadf?les\filestmp\201332217392akmopa?.xls:Average Response Time (ms)
By Frontend|SpreadAnalysis|Backend Calls|\\s0134iffs01\spreadf?les\filestmp\201332217392akmopa?.xls:Responses Per Interval
Is there a way to tell CA APM not to collect any metrics from xls file usage?
Why do you get these metrics? They are not formatted like OOTB Frontend metrics (Frontends|Apps|<appname>:<metric name>). Are you using custom tracers?
The applications are designed to Access some Excel files to do their work.
Users are uploading or downloading data via excel files.
CA APM somehow catches these operations and measures them.
I want to find a way to tell CA APM not to collect any statistics about these operations?
How can I do that?
some of our instrumentations provide filter mechanism (SQL for example) but I think we need to understand first from which tracer in our agent these metrics are coming from.
Can you help us on that part?
First try to catch a transaction trace which contains one of these "akmopa?xls" metrics. Once you click on the element you will find in the Properties a class and method name for that traced component.
Next, can you please go to your AutoProbe.log and look for that class. Together with the method it should list all injected tracers.
That would help us most to find the right solution for you.
We are using .NET applications in Microsoft IIS environment and the application servers are querying MS SQL databases.
I will try to catch a transaction trace and let you know the result.
Hello, I had the same issue and created a post (https://communities.ca.com/message/242165649-excel-files-used-as-temporal-backends).
I received help from internal support to fix it by using the following skip: