John, What is exactly slow in your setup? Have you tried something like iperf to make sure that it is not a bandwith issue from your OTRS box to the mssql box? Have you measured the query on the Microsoft SQL server end to make sure that there is no way the query can be optimized? What is the load on the MS SQL box and on the OTRS box when the query is executed?
The main point is, there are many factors into play that can cause your issues. You have to rule them out one by one. I have worked with a Perl DBI >> MS SQL Server connection that performed really well; so you should be able to achieve good performance. Kind regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl 2008/12/15 John Late <jlat...@yahoo.com>: > Hello > > I am trying to connect my otrs installation to a mssql database. > I am using this connection string but it is really slow and it is impacting > the system performance. It connects but the performance is far away from > mysql. > > $Self->{'Database::Type'} = q/mssql/; > $Self->{'Database'} = q/otrs/; > $Self->{'DatabaseUser'} = q/jurl/; > $Self->{'DatabasePw'} = q/hohoho/; > $Self->{DatabaseDSN} = q/DBI:ODBC:driver={SQL > Server};Server=192.168.101.22,1433;database=otrs;/; > > Please, after Googling and search in the list, can somebody provide an > alternative connection string? > > Thank you in advance > John > > _______________________________________________ > 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