CRM Performance issue

[Former Member]

Hi,

RAM 16 GB

CPU's 1 CPU of type AMD64 Level 6 (Mod 15 Step 😎 2515 MHz

OS Windows 2003 Server Enterprise Service Pack 2

DATABASE Oracle 10.2.0.2.0

Kernel Release and patch Release 700 and patch level 146

SAP Product SAP CRM 2007 (6.0)

Component Software Component Release Level Support Package

SAP_ABA 700 15 SAPKA70015

SAP_BASIS 700 15 SAPKB70015

PI_BASIS 2005_1_700 15 SAPKIPYJ7F

ST-PI 2005_1_700 5 SAPKITLQI5

CRMUIF 600 3 SAPK-60003INCRMUIF

SAP_BW 700 17 SAPKW70017

SAP_AP 700 13 SAPKNA7013

BBPCRM 600 2 SAPKU60002

ST-A/PI 01L_CRM570 0 -

And we are using WEB UI.

This is our CRM environment .But the performance is very slow.

Total No of user - 30

And i have checked Table space size enough space is there.

In st02 i checked buffer ratio almost 99% for all buffer.

particularly CRMD_ORDER tcode running ver slow.

kindly help me.

[markus_doehr2]

You really have only 1 CPU? That means that CPU must handle

- the operating system

- the database

- the SAP application

With 30 users the system will be just overloaded.

Markus

[Former Member]

Thanx

4 CPU we are having.

kvl

[Former Member]

Hi,

i found deadlock for CRMD_ORDER tcode, and updation taking long time.

kindly help me.

kvl

[Former Member]

i found deadlock for CRMD_ORDER tcode

Can you explin where you found it ? Step by step explain what you see.

Are you see anythng in DB01 t-code ?

More information.

[Former Member]

Hi,

Thanx

in db01 i found deadlock.

whenever 2 or 3 users running CRMD_ORDER i noticed in sm50 screen it reading and updating INDX table. that time it is taking long time and if i check db01 i found entires.

kvl

[Former Member]

Can you provide MORE information ,

what do you see in db01 ..

Regards.

[Former Member]

Hi,

In db01 i found 2 entires.

hold and wait entries.

kvl

[Former Member]

WOW, can you POST what do you see in DB01 ???????

P.S. try to check in St04 the V$LOCK Oracle view also ....