Skip to Content

why IQ 16.1 option on threads is kind of high for server

Dear Sirs,

I reviewed Best Practice of IQ16

SAPNote 2570328 - SAP IQ Best Practices Guide

https://launchpad.support.sap.com/#/notes/2570328

and found some question regarding to suggestion on threads and query parallel as following, it is kind of high for threads per connection/team ,

do you get similar question on these options,

Please help to advise. Any comment will be very thankful.

Best regards,

Robert

/* if cpu cores is much smaller than 64, such as 20 cores, why we set this to 64 */

'PUBLIC','Max_Query_Parallelism','64'

/** threads per team should be twice the value of per connection **/
'PUBLIC','Max_IQ_Threads_Per_Connection','144'
'PUBLIC','Max_IQ_Threads_Per_Team','144'

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers