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 pipeline to improve MSSQL performance? Our DBA will not like moving back to MySQL :(

Kind Regards,

Wouter

Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Boris Wagener
Verzonden: vrijdag 27 april 2012 10:24
Aan: User questions and discussions about OTRS.
Onderwerp: Re: [otrs] OTRS 3.0.11 on MSSQL 2008R2 performance

there is no nytive Perl driver for MSSQL, as far as i know that ist the problem.
Use MySQL:-)

2012/4/27 Wouter Mignon <wouter.mignon@khleuven.be>

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 problem seems to be the number of queries OTRS does to build up its pages.

SQL Benchmark feature within OTRS (“normal” test):

Insert Time:       10000    30 s :-( Should not take more than 5's on an average system.

Update Time:    10000    29 s :-( Should not take more than 9's on an average system.

Select Time:       10000    25 s :-( Should not take more than 6's on an average system.

Delete Time:     10000    21 s :-( Should not take more than 5's on an average system.

Multiplier:          * 1          s             

Any ideas?

Kind Regards,

Wouter

---------------------------------------------------------------------
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