OTRS performance MSSQL DB Connection

[aph]

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.

Unbenannt_46.PNG

The same behaviour is not observed on a virtual machine and the performance is much better.

Unbenannt_48.PNG

What could be the reason why OTRS is unable to maintain database connection? How could this problem be solved?
Using MySQL isn't an option, since the relevant departments don't have the experties (they prefer MSSQL)
Your help is greatly appreciated.
Thanks

[crythias]

use mysql. oh. you can't.

[aph]

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.

[aph]

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

[jojo]

MS SQL is slow due to ODBC as driver. So it will always lack in performance for OTRS