I'm having some performance issues with OTRS and MSSQL. According to the MSSQL protocol, everytime I perform any action in OTRS web interface (say clicking on 'create new phone ticket'), the 'otrs' database is started afresh. As a result OTRS is very slow.
Using MySQL isn't an option, since the relevant departments don't have the experties (they prefer MSSQL)
Your help is greatly appreciated.
Thanks
The same behaviour is not observed on a virtual machine and the performance is much better.
What could be the reason why OTRS is unable to maintain database connection? How could this problem be solved?OTRS performance MSSQL DB Connection
Moderator: crythias
OTRS performance MSSQL DB Connection
You do not have the required permissions to view the files attached to this post.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: OTRS performance MSSQL DB Connection
use mysql. oh. you can't.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: OTRS performance MSSQL DB Connection
It may be helpful to some. I was able to improve performance by disabling the Product News (DashboardBackend###0000-ProductNotify) and OTRS News (DashboardBackend###0410-RSS) from Framework -> Frontend::Agent::Dashboard. In my case, OTRS is installed on a server and being behind the firewall OTRS wasn't able to fetch the above feeds.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Re: OTRS performance MSSQL DB Connection
I would be interested in knowing, whether anyone was able to improve the MSSQL performance by other means as well. I'm sure I'm not the only one who can't use a MySQL database 

OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Re: OTRS performance MSSQL DB Connection
MS SQL is slow due to ODBC as driver. So it will always lack in performance for OTRS
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com