Reporting Examples › 6.11 Track Memory Usage of Database Workload

6.11 Track Memory Usage of Database Workload

PROBLEM:

    Determining if a change may have altered the real memory
    requirements (working set size) of a given workload or
    subsystem component is essential in the management of
    complex software.


DATABASE FILES TO BE ACCESSED:

    &RWLMW..WLMSEC01-05
       Last five weeks of the Service Class Resource
       Consumption File.


SUGGESTED SAS FACILITIES TO BE USED FOR REPORTING:

    PROC CHART to produce histogram displaying total number
    of Main Storage Occupancy (MSO) service units consumed by
    summarized zone, grouped by week, to show a trend, if
    any.


SAS CODE EXAMPLE:

************************************************************;
* PERFORMANCE GROUP WORKING SET SIZE TREND                 *;
* WORKLOAD MAIN STORAGE OCCUPANCY TREND                    *;
************************************************************;
 DATA;
 SET &RWLMW..WLMSEC01 &RWLMW..WLMSEC02 &RWLMW..WLMSEC03
     &RWLMW..WLMSEC04;
 IF WLMCLASS='DATABPRD';
 PROC CHART; VBAR ZONE / TYPE=SUM SUMVAR=SECTOMSO NOSPACE
             NOZEROS GROUP=WEEK;
 TITLE "MAIN STORAGE OCCUPANCY TREND FOR WORKLOAD DATABASE";
 TITLE2 "WEEK 32 IS 4/9, 33 - 8/16, 34 - 8/23 35 - 8/30";


GENERATED OUTPUT REPORT:

    Figure 6-9 illustrates the output reports produced by the
    SAS code illustrated above.

 
  MAIN STORAGE OCCUPANCY TREND FOR WORKLOAD DATABASE                                           10:18 Friday, September 3, yyyy   1
  WEEK 32 IS 4/9, 33 - 8/16, 34 - 8/23 35 - 8/30
 
  Storage Service Units Sum
 
               |                                                                                    *****
  140000000000 +                                                                                    *****
               |                                                                                    *****
               |                                                                                    *****
               |                                                                                    *****
  120000000000 +                                                                                    *****
               |                                                                                    *****
               |                                                                                    *****   *****
               |                                                                                    *****   *****
  100000000000 +                                                                                    *****   *****
               |                                                                                    *****   *****
               |                                                                                    *****   *****
               |                              *****                      *****                      *****   *****
   80000000000 +   *****                      *****                      *****                      *****   *****
               |   *****   *****              *****   *****              *****   *****              *****   *****
               |   *****   *****              *****   *****              *****   *****              *****   *****
               |   *****   *****              *****   *****              *****   *****              *****   *****
   60000000000 +   *****   *****              *****   *****              *****   *****              *****   *****
               |   *****   *****              *****   *****              *****   *****              *****   *****
               |   *****   *****              *****   *****              *****   *****              *****   *****   *****
               |   *****   *****   *****      *****   *****              *****   *****              *****   *****   *****
   40000000000 +   *****   *****   *****      *****   *****   *****      *****   *****              *****   *****   *****
               |   *****   *****   *****      *****   *****   *****      *****   *****   *****      *****   *****   *****
               |   *****   *****   *****      *****   *****   *****      *****   *****   *****      *****   *****   *****
               |   *****   *****   *****      *****   *****   *****      *****   *****   *****      *****   *****   *****
   20000000000 +   *****   *****   *****      *****   *****   *****      *****   *****   *****      *****   *****   *****
               |   *****   *****   *****      *****   *****   *****      *****   *****   *****      *****   *****   *****
               |   *****   *****   *****      *****   *****   *****      *****   *****   *****      *****   *****   *****
               |   *****   *****   *****      *****   *****   *****      *****   *****   *****      *****   *****   *****
               ------------------------------------------------------------------------------------------------------------------
                     1       2       3          1       2       3          1       2       3          1       2       3      ZONE
 
                   |-------- 32 -------|      |-------- 33 -------|      |-------- 34 -------|      |-------- 35 -------|    WEEK
 
 

Figure 6-9.  Workload Group Working Set Size