Skip navigation
Contact Us
841 Views 5 Replies Latest reply: Nov 8, 2012 9:52 PM by Thom Biernat RSS
fardeen khan Apprentice 129 posts since
Dec 10, 2009
Currently Being Moderated

Nov 6, 2012 5:15 AM

Question regarding peformance?

  Dear ALL,

If suppose my code is running fine since last 2 yrs , but reporting team says since last 2 days its taking too much of time to generate a report,

even every thing is same since last 2yrs , how can i justify this situatuion and how how can resolve this performance issue from etl side??

  • Santhoshi Raghavan Novice 49 posts since
    Aug 14, 2012
    Currently Being Moderated
    Nov 6, 2012 8:58 AM (in response to fardeen khan)
    Question regarding peformance?

    Hi,

     

    Take a trend of the time interval for say 3 - 4 weeks in excel.

    you might find, when the deviation started.

     

    hope this helps

  • nithya shanmugam Novice 58 posts since
    Jan 11, 2012
    Currently Being Moderated
    Nov 7, 2012 11:58 PM (in response to fardeen khan)
    Question regarding peformance?

    Hi Faradeen,

     

    Performance will affect due to same query or same server executed by many people at the same time.

     

     

     

    Regards,

    Nithya S.

    • Sri 1236 Apprentice 265 posts since
      Mar 21, 2011
      Currently Being Moderated
      Nov 8, 2012 1:23 PM (in response to nithya shanmugam)
      Question regarding peformance?

      Hi Fardeen,

       

      As our folks said, there could be many reasons for the degradation of queries performance.

       

      1) over the past two years, data might have increased enormously in the tgt table. You may have to take a look at the indexes created, database spaces etc.

       

      2) if tgt is Teradata, consider collecting statistics on key columns.

       

      3)  use query analyzer  to see which join in the query is taking long time to perform its action.

       

      I hope this may help u a bit and keep us informed.

       

      Thanks.

      • Thom Biernat Newbie 4 posts since
        Jan 31, 2004
        Currently Being Moderated
        Nov 8, 2012 9:52 PM (in response to Sri 1236)
        Question regarding peformance?

        Just to clarify...is the issue the report is taking long or the informatica session?

         

        If it's the report...you need to tune the query..run the query straight against the database..generate an Explain plan and investigate rewriting, adding indexes to fields in WHERE clause...Database statistics.  The query should run fast against the database.  As tables getting bigger, the database tries to run the query a bit different, or statistics become outdated and old. If you don't have experience tuning SQL..I recommend having a DBA look at your query.

         

        If it's the session taking long..you need to go through the process of:

        1. Where's the bottleneck - source, transformations, target, session?  Tons of ways to figure out...check the session log...look at Thread Statistics...look careful at the times and find the time where something is taking very long...

         

        hope that helps

More Like This

  • Retrieving data ...

Bookmarked By (0)