Bug 780530 (SOA-2965) - Tune Teiid configuration for out-of-the-box use on a production level machine.
Summary: Tune Teiid configuration for out-of-the-box use on a production level machine.
Keywords:
Status: CLOSED WONTFIX
Alias: SOA-2965
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: unspecified
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On: 780875
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-03-07 22:40 UTC by Van Halbert
Modified: 2015-02-25 17:05 UTC (History)
8 users (show)

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.
Clone Of:
Environment:
Last Closed: 2015-02-25 17:05:26 UTC
Type: Enhancement


Attachments (Terms of Use)
config_chgs.txt (1.81 KB, text/plain)
2011-08-25 21:04 UTC, Van Halbert
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JBDVPL-34 0 Critical Closed Run performance benchmark 2015-02-24 14:33:32 UTC
Red Hat Issue Tracker SOA-2965 0 Critical Closed Tune Teiid configuration for out-of-the-box use on a production level machine. 2014-08-19 01:23:03 UTC
Red Hat Issue Tracker SOA-3331 0 Blocker Closed EDS performance tests shows a performance scalability degradation with large result sets 2014-08-19 01:23:03 UTC

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),.


Note You need to log in before you can comment on or make changes to this bug.