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