10 Replies Latest reply: Jul 2, 2013 3:57 AM by kleemola RSS

Pulling 7-mode performance data from DFM in WFA 2.0

TIMHOIBERG
Currently Being Moderated

Hi All,

 

After recently upgrading to WFA 2.0 and having a poke around the database I noticed a schema for 7-mode performance data. Unfortunately the tables for array_performance and aggr_performance are empty and don't seem to be updating when WFA hits up the DFM server. Is there any additional configuration I need to do in either WFA or DFM to get this working?

  • Re: Pulling 7-mode performance data from DFM in WFA 2.0
    kandati
    Currently Being Moderated

    There is separate DataSourceTypes introduced in WFA 2.0 for PA 7-mode and C-mode.

    You need to do PA data acquisition using these types with server(DFM) credentials, not the DB credentials.

     

    Hope it helps.

     

    Warm Regards

    Sivaprasad K

    • Re: Pulling 7-mode performance data from DFM in WFA 2.0
      TIMHOIBERG
      Currently Being Moderated

      Thanks Sivaprasad,

       

      I've created the new Data Source for the performance data but when it tries to acquire the data it runs for about 8 minutes then returns with the following error message:

       

      Error running data acquisition script: Exception calling "InvokeElem" with "1" argument(s): "host-list-info-iter-next: Iterator cannot be obtained."

       

      I changed the data source to our other DFM server and the command successfully completed, however that particular DFM server doesn't collect performance data.

       

      Anyone come across this issue before?

      • Re: Pulling 7-mode performance data from DFM in WFA 2.0
        kandati
        Currently Being Moderated

        Hi,

         

        I'm still trying to figure out your first case when it's start giving this failure..!

        In 2nd case, can you please recheck the below PA options are enabled in your DFM server..!

         

        C:\Documents and Settings\Administrator\Desktop>dfm option list perfAdvisorEnabled

        Option             Value

        ------------------ ------------------------------

        perfAdvisorEnabled Enabled

         

        and in, #dfm host diag <host> , the PA options are set like below,

         

        Performance Advisor Checklist

        perfAdvisorEnabled     Passed

        hostType               Passed

        hostRevision           Passed

        hostLogin              Passed

        perfAdvisorTransport   Passed

         

        once you make sure of all these settings, could you please retry the PA acquisition again in both cases..!

        BTW, what acquisition you are trying, is it 7-mode PA or C-mode PA.

         

        Warm Regards

        Sivaprasad K

        • Re: Pulling 7-mode performance data from DFM in WFA 2.0
          TIMHOIBERG
          Currently Being Moderated

          I kept trying and it finally managed to pull down the data, which turned out to be about 55,000 rows for both tables, so I'm guessing that was probably the cause of my issues earlier. I think going forward I won't bother with performance data given the sheer volume of information, but it's nice to get it working.

           

          Thanks for your help.

          • Re: Pulling 7-mode performance data from DFM in WFA 2.0
            tanzim
            Currently Being Moderated

            Hi Tim,

             

            I have a few queries to help me better understand your experience with the 7-Mode performance data source:

            • How did you intend to use the performance data in your environment? Do you plan on building any custom content(filters/finders/)?Do you have any workflows designed around performance data?
            • Related to the query above, does the current performance related pre-canned content meet your requirements?

                   Is there any more performance related data you'd like available?

            • Finally, why would you not work with performance data?
              1. Sheer volume of information
              2. Performance data source acquisition time is significant
              3. No use case for performance data
              4. All of the above

                      With respect to Point 1, WFA provides a neat feature of disabling cache acquisition for specified dictionary entries. This feature was primarily developed to address the issue of significant volume of data acquired per dictionary entry, which in your case happens to be Aggregate_Performance and Array_Performance.

            However,in case you are working with any one of  the objects, you can add the other to the "Disable acquisition for Dictionary Entries" list (Tools -> WFA Configuration -> Other). This would delete all current data acquired and disable acquiring data for the dictionary object in subsequent acquisitions.

             

            Regards,

            Tanzim

             

             

             

            Regards,

            Tanzim

More Like This

  • Retrieving data ...