Skip to Content
avatar image
Former Member

SAP IQ16 Performace Issue

Hi,

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.

Regards,

Praveen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers