That clears it up a little. Still one isue you did not address: is the ms-sql server running on a different box? have you made sure that the performance loss is not caused by the network? Try and use a tool like iperf to measure the speed between OTRS and the database server.
There is a blocker bug open since may mentioning degraded performance with MS-SQL: [http://bugs.otrs.org/show_bug.cgi?id=2530] So this might be actually causing the performance issues you are experiencing. So if you would like to deploy OTRS in a heavy load environment you might consider choosing another DBMS than MS-SQL for the moment (or fixing the bug I mentioned ;-) And of course you can contact the guys over at OTRS.com and discuss what they can do for you. Kind regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Tue, Dec 16, 2008 at 14:58, John Late <jlat...@yahoo.com> wrote: > Hello Michiel > > The CPU never goes up to 50%. > I am using the default Windows installation that otrs provides, and I > modified the DBType parameter and the connection to use a mssql db instead > of mysql. > > These are the differences between my installation and the default provided > by the product. > > When I use the load generator to simulate some concurrent users the behavior > of the application is so different: > * with mysql all is as expected and depending on the load the responses > are more or less quick > * but with mssql all the system is bloqued with a very low load (compared > with mysql), and after some tests the apache server is bloqued too > > I am using now the MS SQL Enterprise Server 2005. No similar system to > FreeDTS is being used. > > Any help will be welcome, as we want to use this system in a large > operational environment and these results are blocking its usage > > Best 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 > Cc: "User questions and discussions about OTRS." <otrs@otrs.org> > Date: Tuesday, December 16, 2008, 1:32 PM > > My connection string was exactly the same; just the server name, > authentication information and the 1433 server port really. > I was not asking if you had enough CPU power in your OTRS servers but > if the CPU usage went up when you executed the SQL statement. This can > be an indicator to where the bottle neck is. For instance, if the CPU > usage of your OTRS box goes way up if you run the SQL statement > against MSSQL (and, for instance, a lot more than if you repeat the > same statement against a mysql database) you have an indication that > the MSSQL driver might be the issue. > Is your OTRS installation on Windows or Unix/Linux? Do you use > something like FreeTDS to connect to MSSQL? > -- > Michiel Beijen > Software Consultant > +31 6 - 457 42 418 > Bee Free IT + http://beefreeit.nl > On Tue, Dec 16, 2008 at 14:21, John Late <jlat...@yahoo.com> wrote: >> 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
