AnsweredAssumed Answered

Alfresco 3.3.5 Enterprise performance lacking

Question asked by snertz on Aug 1, 2014
Latest reply on Aug 4, 2014 by snertz
Hi all,

Currently we have an Alfresco Enterprise production environment, version 3.3.5.
The performance of this environment is lacking since the repository is growing.
If we browse through the Alfresco Explorer it takes up to 10 seconds to open an empty folder. It used to be less then 1 second.

The Alfresco environment is a standard installation with minor content-model changes. We only added a string field to the content metadata-model.

Currently we have the following extra configuration settings apart from the standard settings:

* alfresco-global.properties:

hibernate.jdbc.fetch_size=150
db.pool.max=275
db.pool.validate.query=SELECT 1 FROM DUAL
system.usages.enabled=false

lucene.indexer.maxFieldLength=1000
index.recovery.maximumPoolSize=20
lucene.indexer.maxDocsForInMemoryMerge=20000
lucene.indexer.maxRamInMbForInMemoryMerge=256
lucene.indexer.maxDocsForInMemoryIndex=20000
lucene.indexer.maxRamInMbForInMemoryIndex=256

* setenv.sh
export CATALINA_OPTS="-Xms8G -Xmx8G -XX:MaxPermSize=512m -XX:PermSize=256M -XX:NewSize=512M -XX:MaxNewSize=2G -XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -XX:+CMSIncrementalPacing -XX:+CMSParallelRemarkEnabled -XX:+UseParNewGC -Xss1m -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=5123 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/opt/alfresco/tomcat/logs"

Our server specifications:

I added two attachments showing the server specifications of the Linux (Alfresco) VM and the Oracle environment.

We tried the following things so far:

- Full reïndexing of the Lucene Indexes.

Do you guys/girls have any idea how we can boost the performance?

Regards,

Vincent Beukers

Attachments

Outcomes