Bug 780530 (SOA-2965)

Summary: Tune Teiid configuration for out-of-the-box use on a production level machine.
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Van Halbert <vhalbert>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED WONTFIX QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: unspecifiedCC: atangrin, dlesage, jpechane, kejohnso, ldimaggi, soa-p-jira, vhalbert, vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2965
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
The best configuration for out-of-the-box use of Data Services 6 on a production level system is currently unknown. Data Services 6 is yet to be exposed to a series of "what if" scenarios to determine the most appropriate configuration to achieve maximum performance.
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-02-25 17:05:26 UTC Type: Enhancement
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On: 780875    
Bug Blocks:    
Attachments:
Description Flags
config_chgs.txt none

Description Van Halbert 2011-03-07 22:40:01 UTC
project_key: SOA

Teiid configuration from the project is tuned for a small machine with just 2 GB's of memory.   This needs to be adjusted for a machine that has, say 64 GB's of memory, a production level machine.

Comment 1 Van Halbert 2011-05-20 16:18:22 UTC
Link: Added: This issue depends JBQA-4648


Comment 2 Van Halbert 2011-08-03 12:14:14 UTC
The changes in Teiid for tuning has been simplified.   Teiid will now make auto-adjustments based on its current environment. And with fewer parameters to tune, this should help with ootb production use.   However, validating this assumption will take resources and hardware.   I realize we have performance test, but what this needs is repetitive testing with varying degrees of change to the existing parameters to verify impact that can give direction to tuning.   Therefore, the status of this issue is up in the air.

Comment 4 Van Halbert 2011-08-25 20:59:27 UTC
Attachment: Added: config_chgs.txt


Comment 5 Van Halbert 2011-08-25 21:03:40 UTC
Attachment: Removed: config_chgs.txt 


Comment 6 Van Halbert 2011-08-25 21:04:07 UTC
Attachment: Added: config_chgs.txt


Comment 7 Van Halbert 2011-08-31 13:46:37 UTC
SOA-3331 is tracking the QE performance testing.

Comment 8 Van Halbert 2011-08-31 13:46:37 UTC
Link: Added: This issue depends SOA-3331


Comment 9 Van Halbert 2012-01-30 20:45:51 UTC
The Teiid auto-tuning changes in 5.2 are looking pretty good.  There are 2 issues, related to QE performance results, that are being investigated.  

I now have a framework that will enable faster turnaround of tests and the comparing performance results so that "What if" testing can be performed in order to make tuning recommendations.

Comment 10 Douglas Palmer 2012-06-29 09:51:16 UTC
This appears to have been fixed in SOA-P 5.2; can we verify on ER4?

Comment 12 wgibson 2012-07-11 14:35:55 UTC
This will need to be moved to post 5.3 to give adequate time to procure hardware and perform "what-if-testing".  We may want to consider waiting to test with 6.0 since there will be significant changes to SOA-P and Teiid coming in 6.0.

Comment 17 JBoss JIRA Server 2015-02-03 18:24:51 UTC
Kim Palko <kpalko> updated the status of jira JBDVPL-34 to Closed

Comment 18 JBoss JIRA Server 2015-02-24 14:31:16 UTC
Anne-Louise Tangring <atangrin> updated the status of jira JBDVPL-34 to Reopened

Comment 19 JBoss JIRA Server 2015-02-24 14:33:32 UTC
Anne-Louise Tangring <atangrin> updated the status of jira JBDVPL-34 to Closed

Comment 20 Van Halbert 2015-02-25 17:05:26 UTC
This will be covered in the Best Practices, Admin guide (tuning) and the use of the new DV sizing application.  Because there's no one size fits all that can be done.  However, I would like to consider adding an enhancement to the installer where we could enable the user to configure the server (i.e., heap size, tune teiid).  But to tune for out-of-the-box use, this doesn't work.  So closing this for and another BZ can be opened for anything specific we would like to do (i.e., installer enhancement),.