Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: reasons for slower performance

    Greetings all,

    My production machine is currently ASE, and I have a weekly process that runs thru CRON that updates, inserts, and deletes against a number of tables in my main production database. Out of nowhere, this particular process is taking 3 times as long to complete. Yesterday, I restored my development database that runs on a slower machine with a backup copy of my main production database. That same process is now again taking 3 times as long to complete as it was on my production database. What are some possible reasons, why is process is taking so long on the production machine, and then on my development database after a backup - restore? Any insight would be appreciated.


    Patrick Quinn

    TQ3 Navigant Sybase Database Administrator

  2. #2
    Join Date
    Dec 2005
    did you try running update stats on the tables & see if it's still taking that much time. you can try this on dev box where you got the production copy. Alternatively you can also check if any key indexes have been dropped or missing which might be causing this issue.

Posting Permissions

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