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

2012-04-27 Thread Steven Carr
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 wil

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

2012-04-27 Thread Wouter Mignon
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 pi

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

2012-04-27 Thread Boris Wagener
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 >

[otrs] OTRS 3.0.11 on MSSQL 2008R2 performance

2012-04-27 Thread 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