OTRS 2.4.5 and MSSQL2005 Slow response

13 Nov 2009

      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.plhttp://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

#        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: nl-info@tel.io | 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).

Dave Lageweg

Michiel Beijen

Shue, Daniel G.

tags

participants (3)