DX Application Performance Management

Expand all | Collapse all

How to exclude metrics from .xls (excel) files

Jump to Best Answer
  • 1.  How to exclude metrics from .xls (excel) files

    Posted 08-13-2015 06:53 AM

    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?



  • 2.  Re: How to exclude metrics from .xls (excel) files

    Posted 08-13-2015 12:54 PM

    Hi Gokhan,

     

    Why do you get these metrics? They are not formatted like OOTB Frontend metrics (Frontends|Apps|<appname>:<metric name>). Are you using custom tracers?

     

    Ciao,

    Guenter



  • 3.  Re: How to exclude metrics from .xls (excel) files

    Posted 08-14-2015 02:59 AM

    Hi Günter,

     

    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?

     

    Regards,

    // Gokhan



  • 4.  Re: How to exclude metrics from .xls (excel) files
    Best Answer

     
    Posted 08-14-2015 05:37 AM

    Hi Gokhan,

     

    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.

     

    Thanks

    Andreas



  • 5.  Re: How to exclude metrics from .xls (excel) files

    Posted 08-14-2015 09:07 AM

    Hi Andreas,

     

    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.

     

    Regards,

    // Gokhan



  • 6.  Re: How to exclude metrics from .xls (excel) files

     
    Posted 04-12-2019 09:31 AM

    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:

    SkipNamespace: [System.Data]System.Data.OleDb

    regards,

    Harold