OTRS on windows and high cpu loads

Hi, recently had to install a system in Windows. The OTRS version is 3.0.9 and I installed in a pretty basic way. Migrated data from 2.2.7 into the new version. Now I notice that the system performs worse than I expected. The system is running Windows2008 server in 32 bit, is a 3.0 Xeon dual core at 3 Ghz and has 6 Gb of ram. Each time a user logs on to OTRS or performs a more complex action the CPU load spikes to 100% and this is largely due to the httpd.exe process. I would have expected that this config would be able to run OTRS oke. I already moved files from database to filesystem, archived 35k tickets (still around 70k tickets in system), did some database optimization (larger key_buffer_size (1024m), added thread_cache_size=40, added table_open_cache = 1024) and activated the WinNT MPM with 150 threads in the httpd.conf. This seems to have no effect on performance. There are around 20 to 30 active agents on the system. - Would I be better of running IIS? - Would I be better of installing Apache under windows myself? Any help / tips are appreciated. Regards, Arnold

Speaking from recent experience, I do not think you'll be happier
under IIS and PerlEx (the latter being the real issue, from my
perspective). Are you using MySQL or MSSQL?
We started with that configuration (IIS and PerlEx) and have steadily
moved toward Apache. I have some ASP.NET apps also hosted under my
helpdesk site so I have remained on IIS as the front end but now just
use it as a reverse proxy to Apache and mod_perl for the /otrs
directory. This seems to be workable.
Overall, I still feel that we have some performance issues, but the
OTRS tools indicate it is slowness in the data access tier.
On Thursday, July 14, 2011, Arnold Ligtvoet
Hi,
recently had to install a system in Windows. The OTRS version is 3.0.9 and I installed in a pretty basic way. Migrated data from 2.2.7 into the new version.
Now I notice that the system performs worse than I expected. The system is running Windows2008 server in 32 bit, is a 3.0 Xeon dual core at 3 Ghz and has 6 Gb of ram. Each time a user logs on to OTRS or performs a more complex action the CPU load spikes to 100% and this is largely due to the httpd.exe process. I would have expected that this config would be able to run OTRS oke.
I already moved files from database to filesystem, archived 35k tickets (still around 70k tickets in system), did some database optimization (larger key_buffer_size (1024m), added thread_cache_size=40, added table_open_cache = 1024) and activated the WinNT MPM with 150 threads in the httpd.conf. This seems to have no effect on performance.
There are around 20 to 30 active agents on the system.
- Would I be better of running IIS? - Would I be better of installing Apache under windows myself?
Any help / tips are appreciated.
Regards, Arnold --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Hi Hugh, thanks for that. I am using MySQL, so basically the complete windows installer from the OTRS site. I have a sneaky suspicion that running OTRS on windows is less than optimized. I will test next week with the same database on a Linux based system running a dualcore E2160 (1.8 Ghz) processor with 4Gb ram. I would have expected to be able to run OTRS with this number of agents. Are there other people running similar systems (around 50k tickets, 25 agents) on windows? Regards, Arnold. Op 16-7-2011 14:43, Hugh Kelley wrote:
Speaking from recent experience, I do not think you'll be happier under IIS and PerlEx (the latter being the real issue, from my perspective). Are you using MySQL or MSSQL?
We started with that configuration (IIS and PerlEx) and have steadily moved toward Apache. I have some ASP.NET apps also hosted under my helpdesk site so I have remained on IIS as the front end but now just use it as a reverse proxy to Apache and mod_perl for the /otrs directory. This seems to be workable.
Overall, I still feel that we have some performance issues, but the OTRS tools indicate it is slowness in the data access tier.
On Thursday, July 14, 2011, Arnold Ligtvoet
wrote: Hi,
recently had to install a system in Windows. The OTRS version is 3.0.9 and I installed in a pretty basic way. Migrated data from 2.2.7 into the new version.
Now I notice that the system performs worse than I expected. The system is running Windows2008 server in 32 bit, is a 3.0 Xeon dual core at 3 Ghz and has 6 Gb of ram. Each time a user logs on to OTRS or performs a more complex action the CPU load spikes to 100% and this is largely due to the httpd.exe process. I would have expected that this config would be able to run OTRS oke.
I already moved files from database to filesystem, archived 35k tickets (still around 70k tickets in system), did some database optimization (larger key_buffer_size (1024m), added thread_cache_size=40, added table_open_cache = 1024) and activated the WinNT MPM with 150 threads in the httpd.conf. This seems to have no effect on performance.
There are around 20 to 30 active agents on the system.
- Would I be better of running IIS? - Would I be better of installing Apache under windows myself?
Any help / tips are appreciated.
Regards, Arnold --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
participants (2)
-
Arnold Ligtvoet
-
Hugh Kelley