Performance issues MS-SQL

[Kilstapeter]

Hi,
We are running OTRS 3.1.6 fresh installed using the provided windows installer package on a VMware virtual Windows 2008 R2 SP1 server.
After the default installation (incl. Apache and Perl) OTRS was configured to use a central MS-SQL database instead of the local MySQL database. The MySQL-service is disabled on the OTRS server.

I ran the SQL-benchmark test and recieved horrible results.
Is there any way to optimize the speed when using MS-SQL as a database for OTRS?
I have tried disabling "EnableMMAP off" and "#EnableSendfile off" in httpd.conf for Apache with no change in the performance result.
Both the OTRS-server and the MSSQL-server are running basically on idle when I perform the test. (both CPU and network)

Ideas anyone?

Regards
Peter

[jojo]

MS SQL will always terrible slow as there is no PERL Dastabase driver and ODBC will be used.

We strongly suggest not to use MS SQL!