You're using MS-SQL 2008; this requires ODBC connection and is slower than running on MySQL or PostgreSQL. Can you please check this link: http://bugs.otrs.org/show_bug.cgi?id=5023#c8 And change the value of LongReadLen to a lower value. Does that affect performance? I'm not sure what exact side-effects it would have at this point, please be warned! -- Mike On Thu, May 12, 2011 at 3:04 PM, Hugh Kelley wrote:

I have now, thanks for the reminder.   There were a few items in to tend to there ( I hadn't enabled Apache:DBI, was missing some minor Perl modules, etc.)

I also enabled the performance logging module which should take a lot of subjectivity out of this.

Regarding the support module, I tried to run the SQL Benchmark and got a less than favorable finding.  However, when I try to re-run it I don't get a fresh run.   How can I force it to run another benchmark?

Hugh

Has anybody else seen this (Windows 2008, Apache 2.2, SQL Server 2008

On Thu, May 12, 2011 at 4:25 AM, Nils Leideck wrote:

...

On 12.05.2011, at 03:53, Hugh Kelley wrote:

...

We've been using OTRS for about six month now (9,000 tickets, 62,000 articles) and I'm starting to notice sluggishness. I've tried switching from IIS + PerlEx to Apache + mod_perl but that hasn't made a noticeable difference. My next move is to investigate archiving.   Has anyone else had a similar experience?  When did others start archiving?  What effect did it have?

Are there other more obvious places to look next?  I've read the tuning guide but it seems like we're pretty small by those standards. http://doc.otrs.org/3.0/en/html/performance-tuning.html

Did you install the Support Assessment module? This one is always a good point to start searching for possible enhancements.

Cheers, Nils

-- Nils Leideck http://webint.cryptonode.de / a Fractal project

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

On Fri, May 13, 2011 at 1:55 PM, Lars Jørgensen wrote:

9,000 tickets is nothing. There is a bottleneck somewhere in your setup. Take a look at load, swap and cpu usage on your server (assuming you're on Linux), and take a long, hard look at your database. If you're runnning MySQL, I can recommend mysqltuner.pl (just "wget mysqltuner.pl" and run it). It's a great tool to get pointers for performance tuning your MySQL server.

mysqltuner.pl can not provide sensible recommendations for Microsoft SQL server :D But yes, it's a nice tool - for MySQL sysadmins/DBAs. -- Mike