Znuny Open Source Ticketsystem

Thanks for your replies....

Have anyone used connection pooling with oracle in OTRS?

Does anyone know where we can configure this?

IS perl DBD::ORACLE is real issue here?

As you guys suggested I run NYTpro and found that DBD::ORACLE was showing 168 MS for single request.

There are other section by this is one seems to be a troublesome...

Ok Thanks for the details. After moving to 6.0.24 seems performance has given us good shape but still not as expected with configuration of infra we are using. what's worst is when 30 users trying to login (login + agent dashboard) in one second (through JMETER) it takes 90 seconds in average. with ...

what we observed that otrs 6.0.6 has performance issue. To verify we deployed both(6.0.6 and 6.0.24) vanilla version on two separate instances and observed the difference, we saw there is a significant difference. We inspected our code too and found no reason to get it slower. So we migrated to late...

What does Dev::Tools::CacheBenchmark ?

Not sure what this is going to help me. I can not make any judgement on this. Any suggestions? I have updated my stats below.

Here is my Stats Display

Yes we have escalations configured. Its business mandate. we can not move it out. But we are thinking of making it DB procedure and removing overhead from application.

No we are not connecting to external database for customer information. only external agency here is email box which is being read by cron jobs scheduled. we have approx 10 mailboxes configured and every minute we are fetching those in parallel. To see if any cron job creates trouble, we stopped all...

Thank you everyone for quick reply: see my comments here: - DNS problems? -- We tried accessing directly by hostname and IP - found same observations. - You can temporarily active the performance log (admin area) to see if all pages are equally slow or just selected ones. -- Performance log also sho...

My OTRS version is 6.0.6. My server configuration is: 11 GB ram, 6 core processor, ORACLE Linux as OS -- Application Server Database is ORACLE 12C, AIX OS -- 25 GB RAM -- Database Server Daily inflow of ticket size is 2K to 3K. Concurrent users count is 10 to 30. We are getting slowness, not able to...