How many DIA processes?

[Former Member]

Hello,

We have complains from the users, especially from chief officers, when they use workflow, and sometimes from other users in any transaction. They complain that sometimes the same transaction wait more time and some times finishies in less.

We use SAP R/3 4.6C Oracle 9.2.0.5 HP-UX 11.23, Support package number 2271, 8 CPUs, 16GB RAM.

We have: Dialog 20

Update (V1) 5

Update (V2) 2

Enqueue 1

Background 5

Spool 1

What do you think, should I use more Dialog process in order to solve the wait times?

With one day work:

0 DIA 3652 waiting Yes 01:21:15

1 DIA 3653 waiting Yes 01:10:23

2 DIA 10897 Running Yes 1 00:43:30

3 DIA 3655 waiting Yes 00:24:51

4 DIA 3656 waiting Yes 00:21:41

5 DIA 3657 waiting Yes 00:24:02

6 DIA 3658 waiting Yes 00:16:04

7 DIA 3659 waiting Yes 00:10:52

8 DIA 3660 waiting Yes 00:09:21

9 DIA 3661 waiting Yes 00:14:38

10 DIA 3663 waiting Yes 00:09:00

11 DIA 3665 waiting Yes 00:05:53

12 DIA 3666 waiting Yes 00:03:11

13 DIA 3667 waiting Yes 00:02:05

14 DIA 3668 waiting Yes 00:04:06

15 DIA 3670 waiting Yes 00:00:30

16 DIA 3671 waiting Yes 00:04:58

17 DIA 3672 waiting Yes 00:00:32

18 DIA 3673 waiting Yes 00:00:31

19 DIA 3674 waiting Yes 00:00:05

20 UPD 3675 waiting Yes 00:02:48

21 UPD 3676 waiting Yes 00:00:03

22 UPD 3677 waiting Yes 00:00:00

23 UPD 3678 waiting Yes 00:00:00

24 UPD 3679 waiting Yes 00:00:00

25 ENQ 3680 waiting Yes 00:00:00

26 BGD 22811 waiting Yes 00:00:03

27 BGD 3686 waiting Yes 00:02:33

28 BGD 3687 waiting Yes 00:00:42

29 BGD 3688 waiting Yes 00:00:38

30 BGD 3689 waiting Yes 00:00:05

31 SPO 3691 waiting Yes 00:14:35

32 UP2 23863 waiting Yes 00:00:04

33 UP2 3695 waiting Yes 00:00:00

Thank you in advance,

Ruzica

[Former Member · Accepted solution]

Hello Ruzica,

I don't think the problem is with your DIA work process count.

You would need to investigate the exact reason for long wait times.

Check for any heavy running heavy jobs.

Check for indexes on frequently used tables.

Check for table statastics.

Check for tablespace free space & grwoth rate

Schedule housekeeping jobs

Avoid 'online' backups during business hours.

Regards,

Ammey Kesarkar

[Former Member · Accepted solution]

Hi Ammerey,

There aren't some heavy running jobs,

I've CheckOpt job scheduled every week.

Tablespaces are OK, and all housekeeping jobs are schedulled.

Online backup is only at night.

I will check on indexes on the tables.

So, you think that if I increase DIA work processes the wait and response times won't decrease?

Thanks,

Ruzica

[Former Member]

We had the same problem in 2 different customers and in both cases the problem was the missing indexes on the tables (bad abap program or just missed indexes).

I would suggest you to analyze the performance of your system with st03n, check the most used tables, the trx that are delaying the most, or try to see if there is a bottleneck somewhere else (networking, users)

Good luck,

[Former Member]

Hi jessica,

Thanks, we also tought of indexes on the most used and on some customized tables.

We start tunning the workflow trx and reports, an then will look in the other most used tables.

Many regards,

Ruzica

[Former Member]

Hi jesicca,

Two hours I'm trying to reward to you point and there is ome problem.

I'll try today again.

Thanks,

Rule

[Former Member]

The Pointsd system is down at the moment..it would take at least a couple of hours more for it to get back on Track

Sri

[Former Member]

Hi Ruzica,

I think i have some useful input.

Similarly when Workflows were scheduledin our systems we had tough times as when the Workflow runs all the dialogue processes are occupied by these RFC connections of a workflow.

Just check the jobs SWWCLEAR ; SWWCOND ; SWWDHEX ; SWWERRE . They r idealy scheduled under the ID WF-BATCH.

They were the culprits and until the jobs run all the Tcodes run slowly. They are initially set to run every 3 minutes. and hence the Clog up.

Just check them and also the number of Dialogue procdesses dedicated to RFC's can be limited inthe system by the parameter settings.

Please let me know if the inputs are helpful and award suitable points for my Inputs.

Br,

Sri

[JPReyes]

HI Ruzica,

You can use transaction ST03N (Load Analysis) to check what is creating the delay, response time, CPU Time, DB Time, etc...

Hope this help!

Juan

Please reward with points if helpful