on 12-22-2017 6:30 AM
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'
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.