Skip to Content
avatar image
Former Member

Performance Issue

Hi All

After completing a full restore of IQ, we noticed severe performance issue for the SAP IQ

Prior to the full database restore, we did not have this issue

Can someone please advise on how to improve the performance

Best Regards

Ade

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 05, 2015 at 10:59 AM

    Can you provide more details about the version, .cfg, dbspaces, underlying disk, etc., first?

    How has performance suffered - loads, queries, both?

    Chris

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 05, 2015 at 12:22 PM

    you may want to also pull off the execution HTML query plans for the LOADs to see where the time was spent.  Also where did you restore the database back to, a different box and different disk subsystem or the same place?  Why did you need to do the restore in the first place?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2015 at 06:31 AM

    Are there any differences of option list between original system and restored system?

    Please post the output of sp_iqcheckoptions.

    ==

    Gi-Sung Jang

    Add comment
    10|10000 characters needed characters exceeded