Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: Please help - sybase sql queries really really slow !!

    The queries on the replicated reporting environment run orders of magnitude slower than on the production node.

    We are using Sybase replication to replicate data from the production node to the reporting node. What takes 15 minutes or so on the production node takes hours on the reporting node for the same data.
    The databases are configured similarily but not exactly due to different hardware on the production and reporting nodes which are comparable in performance. What is puzzling is that sometimes we can get the same report to run in about the same times on the production and reporting nodes Sometimes it would run in 15 minutes on the reporting node and then at other times several hours. There is no load on the reporting node other than a few pilot users and replicated data. The query plans on the prod and reporting nodes are different yet the same data and indexes are used. Sometimes the query plans would be the same.

    We are running TRU 64 Unix on the production node and AIX on the reporting node with the following versions

    Production
    Adaptive Server Enterprise/11.9.2.1/1080/P/SWR 8568 ESD 1/Digital UNIX/OSF1 V4.0/OPT/Tue Aug 24 13:59:35 1999

    Reporting

    Adaptive Server Enterprise/11.9.2.1/1080/P/SWR 8570 ESD 1/RS6000/AIX 4.2.1/FBO/Tue Aug 24 13:29:47 1999

    HELP WOULD BE GREATLY APPRECIATED !

  2. #2
    Join Date
    Feb 2004
    Location
    Norway
    Posts
    7

    Re: Please help - sybase sql queries really really slow !!

    Originally posted by newtoboard
    The queries on the replicated reporting environment run orders of magnitude slower than on the production node.
    Don't know how relevant this is for you, but when we upgraded our ASE's from 11.5 to 12.5 on Tru64, we experienced that many small queries (mostly client requests using cursors) were taking an awfully long time (a lot longer than before our soft- and hardware upgrade) while the server load was near zero.

    The configuration element that worked like magic for us was "max packet network size". We increased it from 512 to 4096, and the queries instantly went up to 10 times faster. (The clients must of course be configured too.)

    Olav

  3. #3
    Join Date
    Feb 2004
    Posts
    28

    Re: Please help - sybase sql queries really really slow !!

    My recommendation is - run update statistics and sp_recomile on your reporting server. It is often the cause for slow running queries.


    cheers,
    j


    Originally posted by newtoboard
    The queries on the replicated reporting environment run orders of magnitude slower than on the production node.

    We are using Sybase replication to replicate data from the production node to the reporting node. What takes 15 minutes or so on the production node takes hours on the reporting node for the same data.
    The databases are configured similarily but not exactly due to different hardware on the production and reporting nodes which are comparable in performance. What is puzzling is that sometimes we can get the same report to run in about the same times on the production and reporting nodes Sometimes it would run in 15 minutes on the reporting node and then at other times several hours. There is no load on the reporting node other than a few pilot users and replicated data. The query plans on the prod and reporting nodes are different yet the same data and indexes are used. Sometimes the query plans would be the same.

    We are running TRU 64 Unix on the production node and AIX on the reporting node with the following versions

    Production
    Adaptive Server Enterprise/11.9.2.1/1080/P/SWR 8568 ESD 1/Digital UNIX/OSF1 V4.0/OPT/Tue Aug 24 13:59:35 1999

    Reporting

    Adaptive Server Enterprise/11.9.2.1/1080/P/SWR 8570 ESD 1/RS6000/AIX 4.2.1/FBO/Tue Aug 24 13:29:47 1999

    HELP WOULD BE GREATLY APPRECIATED !

Posting Permissions

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