Results 1 to 5 of 5

Thread: Performance --

  1. #1
    Join Date
    Oct 2002
    Posts
    6

    Exclamation Unanswered: Performance --

    I have 5 DB (for different clients) on the same Server (Sybase 12.5) and each DB have a connexion to run an the same aplication.
    The aplication run very fast with 4DB and very ,very slowly with one !!
    All DB have the same schema.
    How can I test if the problem is DB??

    Thank you
    Sorina

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Having the same schema does not matter for performance, what about the data?

    Do you run update stats?

    Cheers,

    Willy

  3. #3
    Join Date
    Oct 2002
    Posts
    6
    I run the stats,I increase with 1G the BD ,I rebuild and run stats..
    It's neccesary to run sp_sysmon?
    Thanks a lot

    Sorina

    Originally posted by willy_and_the_ci
    Having the same schema does not matter for performance, what about the data?

    Do you run update stats?

    Cheers,

    Willy

  4. #4
    Join Date
    Mar 2003
    Location
    Vienna
    Posts
    24

    Arrow Hmmm...

    Hi,

    try to run update statistic on the tables and the indexes. Also try to run sp_recompile and if you have large unpartitioned tables try to partition them.

    Cheers,

    SL

  5. #5
    Join Date
    Oct 2002
    Posts
    6

    Re: Hmmm...

    Originally posted by clarus
    Hi,

    try to run update statistic on the tables and the indexes. Also try to run sp_recompile and if you have large unpartitioned tables try to partition them.

    Cheers,

    SL
    Thank you very much...
    Sorina

Posting Permissions

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