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 <wouter.mig...@khleuven.be> 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-boun...@otrs.org [mailto:otrs-boun...@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.mig...@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 > > > > > --------------------------------------------------------------------- > 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
