Re: [otrs] OTRS 3.0.11 on MSSQL 2008R2 performance

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 will require some tinkering with the underlying OTRS code. Steve On 27 April 2012 12: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