Hello well, I am doing some performance tests with a load generator. I amb doing the tests using two servers (each one with 4 CPU) and they have enough memory and disk space. One has the application and the other the database. They are in a dedicated environment so no other applications are using them. I run a test using the mysql, and then the same test in the same architecture running the mssql database. The difference is so big (5 times slowest) to think that the problem is the connection (or the scripts for mssql). Can you provide your connection string (or a sample)? Thank you very much Regards John
--- On Tue, 12/16/08, Michiel Beijen <mich...@beefreeit.nl> wrote: From: Michiel Beijen <mich...@beefreeit.nl> Subject: Re: [otrs] Question about Database Connection (mssql) To: jlat...@yahoo.com, "User questions and discussions about OTRS." <otrs@otrs.org> Date: Tuesday, December 16, 2008, 12:49 PM 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