[cle-release-team] Sakai 2.9 Performance Issues

[Beth Kirschner]

I just wanted to provide everyone a quick update on our 2.9 status -- we found that for some unknown reason, the Oracle database was reporting long wait times waiting for the application server to respond after a query of large CLOB data. The application server itself was not even close to cpu capacity, so we're still stumped as to why this occurred. The slow wait time was reproducible even with a JSP file that read data using the same oracle database pooled connections, but was not otherwise using any Sakai modules. Restarting the application server cleared up the problem, but we're still investigating the root cause. 

- Beth

On Jan 2, 2013, at 11:40 AM, Beth Kirschner wrote:

> Hi all,
> 
> UM upgraded to Sakai 2.9 last weekend, and we're seeing some significant performance issues even under low usage. Classes start on Monday, so we're looking to see what can be done to mitigate the problem between now and then. We're seeing very slow user response times for some users/sites, but it's not clear where the problem is. The database is showing long DB Wait Times, meaning the database is waiting on the appserver to respond. We have noticed that the ehache settings need to be updated (https://jira.sakaiproject.org/browse/UMICH-720), but are skeptical that this is the root cause. We're running pretty close to Sakai 2.9.0, but with several additional contrib tools that may or may not be a factor. Any advice or observations would be appreciated - we'll keep you informed on what we find as well.
> 
> Has anyone updated the release notes in regards to deprecation of the maxElementsInMemory ehcache setting (https://jira.sakaiproject.org/browse/SAK-23096)? In case other institutions are changing this setting, they should no that it will have no affect and needs to be changed to maxEntriesLocalHeap. 
> 
> Thanks,
> - Beth