Re: [otrs] Question about Database Connection (mssql)

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

From: Michiel Beijen Subject: Re: [otrs] Question about Database Connection (mssql) To: jlate76@yahoo.com Cc: "User questions and discussions about OTRS." 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 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 wrote:

From: Michiel Beijen Subject: Re: [otrs] Question about Database Connection (mssql) To: jlate76@yahoo.com, "User questions and discussions about OTRS." 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 :

...

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