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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com