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 <[email protected]> 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 <[email protected]>
> 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
>
---------------------------------------------------------------------
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

Reply via email to