DX Application Performance Management

  • 1.  Introscope JDBC API - Performance

    Posted Nov 29, 2012 06:31 PM
    Are there any tuning parameters (or code logic) that can help speed up the retrieval of records using the IntroscopeJDBC API? For instance, right now I am trying to extract 5 days worth of data for one particular metric from a 8.1.1 EM, and it took about 570 seconds to extract roughly 25K records and write them to a CSV file. I am looking to do this extraction for at least 5 other metrics across another 40-50 agents, so a little speed would make things easier.

    Any suggestions?

    Thanks,
    AD


  • 2.  RE: Introscope JDBC API - Performance
    Best Answer

    Broadcom Employee
    Posted Dec 04, 2012 09:19 AM
    Arjun,
    I'd suggest you use the Excel Integration Kit or the Easy Integration Kit from the Field Extensions.

    It allows you to use SQL queries to request data into CSV format without the need to program anything.

    -Hiko


  • 3.  RE: Introscope JDBC API - Performance

    Posted Dec 05, 2012 03:31 PM
    Yes, the problem with the Easy toolkit is, it allows us to specify the Relative time for extraction. For example, last 45 minutes, last 1hour, etc and not a custom time period. I tried performing a similar extraction though, just to gauge the time for extraction and it more or less appears to be the same.

    Thanks for the suggestion though.


    Thanks,
    AD