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