ECC6 - DEV & QAS Performance Very Slow

[Former Member]

Dear Experts,

We have one Sunfire T2000 server with 4 processors (1000 MHz X 4) with 16 GB RAM.

We have 2 zones created in this server for DEV & QAS. Both are completely separate from each other with their own database.

Our Environment is ECC6 / SunOS 5.10 / Oracle 10.2.0.2

DEV System:

Dialog WP = 9

Background WP = 4

Update WP = 2

Update2 WP = 1

Enqueue WP = 1

Spool WP = 1

-

---

Total WP = 18

-

---

QAS System:

Dialog WP = 8

Background WP = 4

Update WP = 1

Update2 WP = 1

Enqueue WP = 1

Spool WP = 1

-

---

Total WP = 16

-

---

Kernel = 206 / BASIS SP = 14 / ABAP SP = 14

Now, the problem is that our DEV & QAS systems are very slow, especially the DEV one is more slower than the QAS. The max. concurrent users at any time in DEV= 20 & in QAS = 25 - 30. Both these systems are restarted everyday for offline backup.

We also see many RED entries in ST02.

Can anyone please help me rectify the bottleneck in the performance of these 2 systems? How to boost the performance of these 2 systems.

Regards,

Ashish

[markus_doehr2]

> We have one Sunfire T2000 server with 4 processors (1000 MHz X 4) with 16 GB RAM.

The "T-Server" series is known to have performance issues, that server architecture is not really suited for single threaded SAP applications (as ABAP + Oracle is).

Read the thread

and also

Oracle Metalink 781763.1 "Migration from fast single threaded CPU machine to CMT UltraSPARC T1 and T2 results in increased CPU reporting"

> Can anyone please help me rectify the bottleneck in the performance of these 2 systems? How to boost the performance of these 2 systems.

The bottleneck is the server architecture. CoolThreads servers (Txxxx) are note the best choice for ABAP (for Java the story is VERY different) - and there's not much you can do about it.

Markus

[Former Member]

Hi,

Please attach below output:

1) ST02

2) ST03N - Workload - Total - Click on the date when the system is slow - Output of Task Type Dialog under "Workload overview"

Cheers!