Re: Performance Question

Jim,

There are 135 drives allocated to this partition.  The jobs experiencing 
poor performance are native.  Here is a screen shot of WRKSYSSTS: 

Sys      Pool   Reserved    Max  ----DB-----  --Non-DB---  Act-   Wait- 
Act- 
Pool    Size M   Size M     Act  Fault Pages  Fault Pages  Wait   Inel 
Inel 
  1    1968.65    299.01  +++++     .0    .0    4.2   5.8   1979     .0  
.0
  2     907.11       .51    180    7.6  34.3   44.7 132.2   1896     .0  
.0
  3    2700.25       .01     40   15.9  77.8   13.3  68.4  946.0     .0  
.0
  4      50.50       .00     10     .4    .6     .6   1.8    2.7     .0  
.0
  5      36.11       .00     40     .0    .1     .5   1.0    4.6     .0  
.0
  6      88.75       .00     10     .0    .5     .0    .0    1.2     .0  
.0
  7      17.06       .00      5     .0    .2     .9   4.7   56.1     .0  
.0
  8    1510.80       .00    300   17.0  74.5   22.3  89.8   1489     .0  
.0
  9      40.78       .00     30     .2   1.0    2.0   4.8   36.6     .0  
.0
 10       5.12       .00      8     .0    .2     .4   1.5   13.3     .0  
.0
 11      43.66       .00      7     .0    .0     .0    .0     .0     .0  
.0
 12    2334.57       .01     57    3.1  10.0    7.7  23.5   1250     .0  
.0
 13     368.73       .01     38    7.8 241.9   10.4  49.6  +++++     .0  
.0

This was for an 8 minute interval.  Pool 3 is a private pool for QBatch 
where the jobs with poor performance run.

I am currently running a TRCASPBAL that will end at 5:00 PM.  I plan on 
doing a ASP balance *USAGE over night tonight.  Unfortunately I won't be 
going to COMMON this time.  Thanks for your help.

Mark 




Mark:

Several items need to be known first.  How many of the 100 arms are
allocated to the specific partition?  How about processor/memory?  You 
said
faulting was not problem, but over what period of time (use about 8 - 10
minute observations without any F5 or F10 activity in the WRKSYSSTS
command)   SQL access or native?