Skip to Content

SAP IQ16 Performace Issue

Jul 26, 2017 at 04:50 AM


avatar image


We migrated Sybase IQ 15.4 to 16Sp8 PL10.

SIQ 15 server has 32 core and 32 GB RAM.

-iqmc 5000 -iqtc 5000 -iqlm 5000

SIQ 16 server has 16 core and 24 GB RAM.

-iqmc 8192 -iqtc 8192 -iqlm 6144

After moving to sybase IQ16 , my data size is 20GB .created HG indexes on columns mentioned in INDEX_ADVISOR.

We are running only one query with 4 tables involved and the CPU is spiking 100%. The query is taking almost double the time compared to 15.4.

Need help to fix this.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers