[rt-users] RT Slow Ticket Updates

[Varun Vyas]

Hardware Info on Application Server is

processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 15
model name      : Intel(R) Xeon(R) CPU            5120  @ 1.86GHz
stepping        : 6
cpu MHz         : 1866.868
cache size      : 64 KB
physical id     : 0
siblings        : 2
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge 
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht t
m pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips        : 3702.78

*processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 15
model name      : Intel(R) Xeon(R) CPU            5120  @ 1.86GHz
stepping        : 6
cpu MHz         : 1866.868
cache size      : 64 KB
physical id     : 0
siblings        : 2
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge 
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht t
m pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips        : 3727.36*


On database server is

*processor       : 0
vendor_id       : GenuineIntel
cpu family      : 15
model           : 4
model name      : Intel(R) Pentium(R) 4 CPU 3.00GHz
stepping        : 1
cpu MHz         : 3000.234
cache size      : 1024 KB
physical id     : 0
siblings        : 2
runqueue        : 0
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 5
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge 
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht t
m
bogomips        : 5989.99

processor       : 1
vendor_id       : GenuineIntel
cpu family      : 15
model           : 4
model name      : Intel(R) Pentium(R) 4 CPU 3.00GHz
stepping        : 1
cpu MHz         : 3000.234
cache size      : 1024 KB
physical id     : 0
siblings        : 2
runqueue        : 0
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 5
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge 
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht t
m
bogomips        : 5989.99*

Joop wrote:
> Varun Vyas wrote:
>> Hello All
>>
>> In my RT application my creating, updating and closing of tickets are 
>> very slow and takes almost 20 sec to insert a ticket and nearly 35 
>> seconds to update a ticket. We have applied many changes on our 
>> database side and application side too. But still our RT application 
>> is not stabilized. We have oracle 9i as our database with indexing 
>> enabled and we also have implemented COMPUTE stats gathering and 
>> apart from that we have also tried to trace SQL for finding the cause 
>> that which queries are taking long time. But still we are not able to 
>> find the cause of sluggishness. And i need to know if anyone has 
>> faced such kind of performance problem before and if yes then where 
>> should i look for improving my performance. And make RT more responsive.
>>   
> We skipped Oracle9i as a production platform and went from 8i to 10g. 
> We had a few customers who ran 9i but can't say if they had 
> performance problems which were related to 9i specifically. As already 
> suggested you can turn on sqltracing in the DBD and/or DBI layer. 
> Check the documentation of DBI and DBD(::Oracle).  Further you could 
> use the info inside the SGA to findout which queries are running real 
> slow by either using Statspack of EnterpriseManager.
>
> As a last resort you could install an instance of OracleXE, which in 
> essence is Oracle10g, and see what kind of performance you get with 
> that. Keep in mind though that XE has a few limitations on database size.
>
> What I and probably the rest of the list would like to know is what is 
> your hardware config and what is your software config, OS/perl 
> versions etc.
> It could be that someone knows that your config combinations is 
> problematic, now we're all shooting in the dark hoping to hit the 
> magic button.
>
>
> Regards,
>
> Joop
>
>
>
>


-- 
Thanks & Regards
Varun Vyas
Software Engineer - Automation
Elitecore Technologies

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090701/c540982c/attachment.htm>