Skip to Content
0

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

Dec 22, 2017 at 06:30 AM

34

avatar image

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'

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

0 Answers