Hi all,
We're getting really bad performance running OTRS 3.0.11 on a Windows 2008R2
machine with MSSQL 2008R2. The database cluster we're running on is powerful,
other applications run perfectly on the same instance.
When tracing the SQL requests to our database we see fast response times, the
there is no nytive Perl driver for MSSQL, as far as i know that ist the
problem.
Use MySQL:-)
2012/4/27 Wouter Mignon
> Hi all,
>
> ** **
>
> We’re getting really bad performance running OTRS 3.0.11 on a Windows
> 2008R2 machine with MSSQL 2008R2. The database cluster we’re running on is
>
Hi Boris
Thanks for your answer. Thanks for confirming what i feared. We were using
MYSQL but switched to MSSQL because it is a supported database and we have more
expertise.
I found problem reports dating from 2003 concering OTRS and DBI:ODBC with mssql
. Any change on the OTRS side in the pi
There is DBD::Sybase http://search.cpan.org/~mewp/DBD-Sybase-1.14/ which
uses FreeTDS to connect to MSSQL servers (I use it on our monitoring
program, Xymon, to check the database is alive and well via perl scripts) -
but I've no idea how/if DBD::Sybase could be utilised by OTRS, my guess is
it wil