Hi Dave, Apache on Windows crashed in different scenarios since we switched to Strawberry Perl. Therefore, since 2.4.4 or so, we decided as a temporary measure to disable mod_perl and run OTRS as regular CGI. This prevents the crashes, but it comes with a performance penalty. See also bug 4270: http://bugs.otrs.org/show_bug.cgi?id=4270
Apache::DBI and Apache::Reload can only work and are only loaded within mod_perl; so you'd see complaints about that in the Support Assessment module. We're working on a solution for the Windows Installer with a CGI accelerator, we have been for quite some time now, and I feel we're close towards a working solution. If we keep progressing as we are now, you could expect a new Windows installer before end of year. Please understand I can't make any promises on that. The CGI accelerator would have impact on the performance you see in the interface. As for the performance benchmarks for the database; I'm afraid they are not completely reliable. Most of the OTRS users actually use MySQL. If you use MySQL with a MyISAM storage engine you would have a non-transactional database, which is by its nature a lot faster than transactional databases. If you would switch the MySQL storage engine to InnoDB, which is transactional, you could expect to see about the same performance as with Microsoft SQL Server. If you have any additional questions, feel free to ask. ((enjoy)) - Michiel Beijen R&D OTRS AG Norsk-Data-Str 1. 61352 Bad Homburg Deutschland T: +31 (0) 6457 42418 F: +49 (0) 9421 56818-18 I: http://www.otrs.com/ Business Location: Bad Homburg, Country Court: Bad Homburg, Commercial register: 10751, Tax ID: 003 240 97505 Chairman of the Board: Burchard Steinbild, Managing Board: André Mindermann (CEO), Martin Edenhofer CU@ IIR Service Desk Forum in Mainz (Germany)<http://www.otrs.com/en/news-and-press/news-details/article/translate-to-english-otrs-at-the-13th-iir-service-desk-forum-2009/?tx_ttnews%5BbackPid%5D=51&cHash=ef91fa143e>and get to know more about OTRS at booth no. 12 from Nov 24-25, 2009! On Fri, Nov 13, 2009 at 1:01 PM, Dave Lageweg <[email protected]> wrote: > Hi There, > > I'm new to OTRS and started yesterday to setup my system. > > My setup is as follow: > > - OTRS is installed on a Windows 2008 r2 (x64) running on a hyperV > server. > - MSSQL2005 is installed on our central DB server in the company. > > I did a fresh install in the windows server and installed OTRS 2.4.5 on > it. After installation i created the DB called OTRS on my SQL Server with > the three scripts supplied with the OTRS installation for MSSQL. > > I adjusted the config of OTRS and removed the MySQL entries and put in > the following DB entries: > > # MSSQL database settings > $Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL > Server};Server=SQLSERVER,1433;database=OTRS;uid=OTRS;pwd=PASSWORD;"; > $Self->{"Database::Type"} = 'mssql'; > $Self->{DatabaseUserTable} = 'users'; > > OTRS is working but the interface is quite slow. > > Under Support Assessment I saw the following critical messages: > > Check Comment State > Check existing framework tables. > 69 Tables Critical > > Webserver Check Comment State > Check if the system uses Apache::DBI. > Apache::DBI should be used to get a better performance (pre establish > database connections). Critical > Check if the system uses Apache::Reload/Apache2::Reload. > You should use Apache::Reload or Apache2::Reload to increase your > performance. Critical > Check used mod_perl version. > You should use mod_perl to increase your performance. Critical > > I already check some things but do not come any further. > > For the "Check existing framework tables." I have no idea what to > check... anyone? > > For the "Check if the system uses Apache::DBI." I created a System DSN on > the windows server to the SQL Server. > And in the apache2-perl-startup.pl script i added the following rule: > Apache::DBI->connect_on_init('DBI:ODBC:OTRS', 'OTRS', 'password'); > > But this didn't improve the situation. > > If i do a SQL Benchmark "1 *Normal" i have the following result at the > moment: > > Result: SQL Key Value Time Comment Insert Time: 10000 37 s :-( Should > not take more than 5s on an average system. Update Time: 10000 39 s :-( > Should > not take more than 9s on an average system. Select Time: 10000 37 s :-( > Should > not take more than 6s on an average system. Delete Time: 10000 35 s :-( > Should > not take more than 5s on an average system. Multiplier: * 1 > > > For the "Apache::reload" i have checked the httpd.conf of apache and > found the rule: > Include 'C:/PROGRA~2/OTRS/OTRS/scripts/apache2-httpd-new.include.conf' > > In this script I found the Apache2::Reload so assume because the include > it's loaded but why do i get this critcal warning? > --- > # load all otrs modules > Perlrequire C:/PROGRA~2/OTRS/OTRS/scripts/apache2-perl-startup.pl > > # Apache::Reload - Reload Perl Modules when Changed on Disk > PerlModule Apache2::Reload > PerlInitHandler Apache2::Reload > PerlModule Apache2::RequestRec > > # set mod_perl2 options > <Location /otrs> > # ErrorDocument 403 /otrs/customer.pl > ErrorDocument 403 /otrs/index.pl > SetHandler perl-script > PerlResponseHandler ModPerl::Registry > Options +ExecCGI > PerlOptions +ParseHeaders > PerlOptions +SetupEnv > Order allow,deny > Allow from all > </Location> > --- > > For "mod_perl" I found in httpd.conf the following: > # load mod_perl > LoadFile 'C:/PROGRA~2/OTRS/StrawberryPerl/perl/bin/perl510.dll' > > So also this looks okay i think... > > Anybody any idea how i can solve these issues? and how to speed up my > config... > > Thanks in advance! > > Best regards, > > Dave > > > ------------------------------ > > Telio Nederland B.V. | Veemkade 540 | 1019 HE Amsterdam | Netherlands > Tel: 0320 750400 | E-Mail: [email protected] | Website: www.tel.io > > > -------------------------------------------------------------------------------- > This electronic message contains information from Telio Nederland BV which > may be privileged or confidential. The information is intended to be for the > use of the individual(s) or entity named above. If you are not the intended > recipient be aware that any disclosure, copying, distribution or use of the > contents of this information is prohibited. If you have received this > electronic message in error, please notify us by telephone or email (to the > numbers or address above) immediately. > > Diese Email enthaelt Informationen der Telio Nederland BV. Diese sind > moeglicherweise vertraulich und ausschliesslich fuer den Adressaten > bestimmt. Jeglicher Zugriff auf diese Email durch andere Personen als den > Adressaten ist untersagt. Sollten Sie nicht der fuer diese Email bestimmte > Adressat sein, ist Ihnen jede Veroeffentlichung, Vervielfaeltigung oder > Weitergabe wie auch das Ergreifen oder Unterlassen von Massnahmen im > Vertrauen auf erlangte Information untersagt. Sollten Sie diese > elektronische Nachricht irrtuemlicherweise erhalten haben, so informieren > Sie uns bitte unverzueglich telefonisch oder per Email (Kontaktdaten > obenstehend). > > --------------------------------------------------------------------- > 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 > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ >
--------------------------------------------------------------------- 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
