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