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

Hi Wouter, The performance loss when running OTRS on Microsoft SQL Server as opposed to MySQL, PostgreSQL or Oracle is caused because of the Perl DBD::ODBC driver and/or Microsoft SQL Server ODBC performance. There are unfortunately not much changes we can bring to the OTRS software which will improve the database performance. That said, starting OTRS 3.1.3, we have implemented a lot of caching throughout the framework, which means that if you'll upgrade to 3.1.3 (or .4 of course) the SELECT statements to the database will be as fast as before (which means slower than on MySQL) but there will be a LOT less of them) so that overall performance might become pretty acceptable for you. Also bringing the Session storage to Filesystem rather than Database will bring you less database access, meaning better performance. HTH, Michiel Beijen Senior Consultant OTRS BV Schipholweg 103 2316 XC Leiden The Netherlands T: +31 71 8200 255 F: +31 71 8200 254 I: http://www.otrs.com Get Connected ! Everything in sync with OTRS 3.1- Be an early bird with our special offer: http://j.mp/xN9wk1 On Fri, Apr 27, 2012 at 13:49, Wouter Mignon wrote:

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

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

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