Where to begin troubleshooting degraded performance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Where to begin troubleshooting degraded performance

  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Where to begin troubleshooting degraded performance

    My boss wrote some crystal reports that run nightly. She had the timing down and their performance was fine. Lately they have been running slower. Over the past month they have just gotten so bad. When she runs them during the day she says it takes a long time for them to complete. I look at the database when she runs them and it is not even breaking a sweat. She says (and I believe her) that the reports have not changed. I have not done anything to the database lately. It is not like there have been a lot of rows added, no indexes have been dropped. I don't see anything on the database side that would raise any red flags. I know this is a vauge question , but could anyone point me in the right direction to even start troubleshooting where the problem could be. I don't see spikes in the DB, everything I look at says there is not a problem with the DB, however they are the same reports and were running fine and now all the suddent they are slow.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    trace the sessions, see what they are doing

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,459

    Cool Reports, reports...so many reports.

    What version?
    9i) statspack report
    10g, 11g) ADDM, AWR reports.
    And when everything else fails, RDA report
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width