NetView Application Service/Workload Ranking

To rank application workloads in ascending or descending order based on response times or character volumes.
mics142
The user chooses the number of applications ranked, the order of ranking, and the variable that is used to rank on. The NetView Application Service/Workload Ranking report provides both response and workload information that can be used in determining possible bottlenecks and/or poor response times.
Format
A 17-column report approximately 132 characters wide. Best suited for hardcopy review but can be reviewed online. The information is summarized and presented by NETWRKID, SYSID, SNTACT1, Data Range, and Zone or Zone by Hour.
Inquiry ID
  • SNTLDA - Application w/in zone - NVSNSA/NVSRTM files
  • SNTLDB - Application w/in hour - NVSNSA/NVSRTM files
  • SNTLD6 - Application w/in zone - SNTNPL file
  • SNTLD7 - Application w/in hour - SNTNPL file
Data Source (File/Timespan)
  • NVSNSA/NVSRTM Days
  • SNTNPL Days
Data elements used
SNTLDA/SNTLDB
  • DURATION
  • SNTACT1
  • RTMAVTTM
  • OBJECTIV
  • RTMNRRNR
  • RTMTRSMN,
  • RTMPCOBS
  • RTMPCOBT
  • RTMTRESC
  • SAMPLES
  • NSATOTSN
  • NSATOTRC,
  • NSATOTTR
  • NSAAVCHS
  • NSAAVCHR
  • NSAAVCHT
  • NSAAVPIU
  • SYSID,
  • NETWRKID
  • DATA
  • ZONE
  • RANKELEM
  • RANKLBL
  • CURRENT
  • DATE,
  • IQ
  • TIME
  • HOUR
SNTLD6/SNTLD7
  • DURATION
  • PLU
  • LSYAVTTM
  • OBJECTIV
  • LSYNRRNR
  • LSYTRSMN
  • LSYPCOBS
  • LSYPCOBT
  • LSYTRESC
  • SAMPLES
  • LSYTOTSN
  • LSYTOTRC
  • LSYTOTTR
  • LSYAVCHS
  • LSYAVCHR
  • LSYAVVHT
  • LSYAVPIU
  • NETWRKID
  • SYSID
  • DATA
  • ZONE
  • RANKELEM
  • RANKLBL
  • DATE TIME
  • IQ,
  • CURRENT
  • HOUR
Calculations
SNTLDA/SNTLDB /* Data Element Derivation (DATE) */; FORMAT DATE DATE7.; LABEL DATE="Date Selection Field"; DATE = DATEPART(ENDTS); ; /* Data Element Derivation (TIME) */; FORMAT TIME TIME11.2; LABEL TIME="Time Selection Field"; TIME = TIMEPART(ENDTS); ; /* Data Element Derivation (DATA) */; LENGTH DATA $15; FORMAT DATA $CHAR15.; LABEL DATA="DATA RANGE"; DATA = ' '; /* SAS System Statements (Load DATA Variable) */; RETAIN DATEA DATEB; LENGTH DATEA DATEB 4.; IF SESTYPE =:'LU-LU' THEN DO; DATEA = MIN(DATEA,STARTTS); DATEB = MAX(DATEB,ENDTS); END; IF _EOF_ THEN DO; DATEA=DATEPART(DATEA); DATEB=DATEPART(DATEB); SUBSTR(DATA,1,7)=PUT(DATEA,DATE7.); SUBSTR(DATA,8,1)='-'; SUBSTR(DATA,9,7)=PUT(DATEB,DATE7.); DROP DATEA DATEB; CALL SYMPUT('S',DATA); %GLOBAL S; END; IF SESTYPE =:'LU-LU'; /* Data Summarization */ %MACRO NEGATE; DATA=SYMGET('S'); %MEND NEGATE; ; /* Data Element Derivation (IQ, &I) */; LENGTH IQ $8; FORMAT IQ $CHAR8.; LABEL IQ="INQUIRE NAME"; IQ = ' '; SUBSTR(IQ,1,1)='('; SUBSTR(IQ,2,6)=SYMGET('INQINAME'); SUBSTR(IQ,8,1)=')'; CALL SYMPUT('I',PUT(IQ,$CHAR8.)); %GLOBAL I; ; /* Data Element Derivation (CURRENT, &C) */; FORMAT CURRENT WEEKDATE15.; LABEL CURRENT="CURRENT DATE"; CURRENT = TODAY(); C=PUT(CURRENT,WEEKDATE15.); C=COMPRESS(C) ; CALL SYMPUT('C',PUT(C,$CHAR12.)); %GLOBAL C; ; /* Data Element Derivation (OBJECTIV) */; LENGTH OBJECTIV $12; FORMAT OBJECTIV $CHAR12.; LABEL OBJECTIV="X PERCENT OF RESPONSE WITHIN XX SECONDS"; OBJECTIV = ' . '; IF RTMPCOBJ GE 0 OR RTMROBTM GE 0 THEN DO; SUBSTR(OBJECTIV,1,3)=PUT(RTMPCOBJ,3.); SUBSTR(OBJECTIV,4,4)='% < '; SUBSTR(OBJECTIV,8,5)=PUT(RTMROBTM,4.1); END; ; /* Data Element Derivation (RANKELEM) */; FORMAT RANKELEM 8.; LABEL RANKELEM="&RL"; RANKELEM = &RANKELEM; ; /* Data Element Derivation (RANKLBL) */; LENGTH RANKLBL $40; FORMAT RANKLBL $CHAR40.; LABEL RANKLBL="LABEL OF RANKING ELEMENT"; RANKLBL = SYMGET('RL'); ; /* Data Element Derivation (RTMPCOBS) */; LENGTH RTMPCOBS $4; FORMAT RTMPCOBS $CHAR4.; LABEL RTMPCOBS="% MET OF SAMPLED"; RTMPCOBS = ' . '; IF RTMPCOBM GE 0 THEN DO; SUBSTR(RTMPCOBS,1,3)=PUT(RTMPCOBM,3.); SUBSTR(RTMPCOBS,4,1)='%'; END; ; /* Data Element Derivation (RTMPCOBT) */; LENGTH RTMPCOBT $4; FORMAT RTMPCOBT $CHAR4.; LABEL RTMPCOBT="% MET OF TOTAL"; RTMPCOBT = ' . '; IF RTMPCTR4 GE 0 THEN DO; SUBSTR(RTMPCOBT,1,3)=PUT(RTMPCTR4,3.); SUBSTR(RTMPCOBT,4,1)='%'; END; ; /* Data Element Derivation (RTMTRSMN) */; FORMAT RTMTRSMN SCALE4.; LABEL RTMTRSMN="TRANSACTIONS PER MINUTE"; RTMTRSMN = .; DURMINS=(DURATION/60); IF DURMINS GT 0 THEN RTMTRSMN=RTMTRESC/DURMINS; ; /* Data Element Derivation (NSATOTSN) */; FORMAT NSATOTSN SCALE4.; LABEL NSATOTSN="TOTAL CHARACTERS SENT"; NSATOTSN = SUM(NSANRCBS,NSANRTBS); ; /* Data Element Derivation (NSATOTRC) */; FORMAT NSATOTRC SCALE4.; LABEL NSATOTRC="TOTAL CHARACTERS RECEIVED"; NSATOTRC = SUM(NSANRCBR,NSANRTBR); ; /* Data Element Derivation (NSATOTTR) */; FORMAT NSATOTTR SCALE4.; LABEL NSATOTTR="TOTAL CHARACTERS TRANSMITTED"; NSATOTTR = SUM(NSANRCBR,NSANRTBR,NSANRCBS,NSANRTBS); ; /* Data Element Derivation (NSAAVCHS) */; FORMAT NSAAVCHS SCALE4.; LABEL NSAAVCHS="AVERAGE CHARACTERS SENT"; NSAAVCHS = .; NSANRFSR=SUM(NSANRCBS,NSANRTBS); IF RTMTRESC GT 0 THEN NSAAVCHS=NSANRFSR/RTMTRESC; ; /* Data Element Derivation (NSAAVCHR) */; FORMAT NSAAVCHR SCALE4.; LABEL NSAAVCHR="AVERAGE CHARACTERS RECEIVED"; NSAAVCHR = .; NSANRFRE=SUM(NSANRCBR,NSANRTBR); IF RTMTRESC NE 0 THEN NSAAVCHR=NSANRFRE/RTMTRESC; ; /* Data Element Derivation (NSAAVCHT) */; FORMAT NSAAVCHT SCALE4.; LABEL NSAAVCHT="AVERAGE TOTAL CHARACTERS TRANSMITTED"; NSAAVCHT = .; NSATOCTR=SUM(NSANRCBS,NSANRTBS,NSANRCBR,NSANRTBR); IF RTMTRESC NE 0 THEN NSAAVCHT=NSATOCTR/RTMTRESC; ; /* Data Element Derivation (NSAAVPIU) */; FORMAT NSAAVPIU SCALE4.; LABEL NSAAVPIU="AVERAGE PIUS PER/RESPONSE"; NSAAVPIU = .; NSANRPIU=SUM(NSANRTPR,NSANRTPS,NSANRCPR,NSANRCPS); IF RTMTRESC GT 0 THEN NSAAVPIU=NSANRPIU/RTMTRESC; ; /* Data Element Derivation (RTMNRRNR) */; FORMAT RTMNRRNR SCALE4.; LABEL RTMNRRNR="NUMBER OF RESPONSES NOT IN RANGE"; RTMNRRNR = .; RTMNRRNR=(RTMTRESC-RTMNRROM); ; SNTLD6/SNTLD7 /* Data Element Derivation (DATE) */; FORMAT DATE DATE7.; LABEL DATE="Date Selection Field"; DATE = DATEPART(ENDTS); ; /* Data Element Derivation (TIME) */; FORMAT TIME TIME11.2; LABEL TIME="Time Selection Field"; TIME = TIMEPART(ENDTS); ; /* Data Element Derivation (DATA) */; LENGTH DATA $15; FORMAT DATA $CHAR15.; LABEL DATA="DATA RANGE"; DATA = ' '; /* SAS System Statements(Derive vars & data select) */; RETAIN DATEA DATEB; LENGTH DATEA DATEB 4.; DATEA = MIN(DATEA,STARTTS); DATEB=MAX(DATEB,ENDTS); IF _EOF_ THEN DO; DATEA=DATEPART(DATEA); DATEB=DATEPART(DATEB); SUBSTR(DATA,1,7)=PUT(DATEA,DATE7.); SUBSTR(DATA,8,1)='-'; SUBSTR(DATA,9,7)=PUT(DATEB,DATE7.); CALL SYMPUT('S',DATA); %GLOBAL S; DROP DATEA DATEB; END; /* Data Summarization */ %MACRO NEGATE; DATA=SYMGET('S'); %MEND NEGATE; ; /* Data Element Derivation (CURRENT, &C) */; FORMAT CURRENT WEEKDATE15.; LABEL CURRENT="CURRENT DATE"; CURRENT = TODAY(); C=PUT(CURRENT,WEEKDATE15.); C=COMPRESS(C) ; CALL SYMPUT('C',PUT(C,$CHAR12.)); %GLOBAL C; ; /* Data Element Derivation (IQ, &I) */; LENGTH IQ $8; FORMAT IQ $CHAR8.; LABEL IQ="Inquire Name"; IQ = ' '; SUBSTR(IQ,1,1)='('; SUBSTR(IQ,2,6)=SYMGET('INQINAME'); SUBSTR(IQ,8,1)=')'; CALL SYMPUT('I',PUT(IQ,$CHAR8.)); %GLOBAL I; ; /* Data Element Derivation (OBJECTIV) */; LENGTH OBJECTIV $12; FORMAT OBJECTIV $CHAR12.; LABEL OBJECTIV="X PERCENT OF RESPONSE WITHIN XX SECONDS"; OBJECTIV = ' . '; IF LSYPCOBJ GE 0 OR LSYROBTM GE 0 THEN DO; SUBSTR(OBJECTIV,1,3)=PUT(LSYPCOBJ,3.); SUBSTR(OBJECTIV,4,4)='% < '; SUBSTR(OBJECTIV,8,5)=PUT(LSYROBTM,4.1); END; ; /* Data Element Derivation (RANKELEM) */; FORMAT RANKELEM 8.; LABEL RANKELEM="&RL"; RANKELEM = &RANKELEM; ; /* Data Element Derivation (RANKLBL) */; LENGTH RANKLBL $40; FORMAT RANKLBL $CHAR40.; LABEL RANKLBL="LABEL OF RANKING ELEMENT"; RANKLBL = SYMGET('RL'); ; /* Data Element Derivation (LSYPCOBS) */; LENGTH LSYPCOBS $4; FORMAT LSYPCOBS $CHAR4.; LABEL LSYPCOBS="% MET OF SAMPLED"; LSYPCOBS = ' . '; IF LSYPCOBM GE 0 THEN DO; SUBSTR(LSYPCOBS,1,3)=PUT(LSYPCOBM,3.); SUBSTR(LSYPCOBS,4,1)='%'; END; ; /* Data Element Derivation (LSYPCOBT) */; LENGTH LSYPCOBT $4; FORMAT LSYPCOBT $CHAR4.; LABEL LSYPCOBT="% MET OF TOTAL"; LSYPCOBT = ' . '; IF LSYPCTR4 GE 0 THEN DO; SUBSTR(LSYPCOBT,1,3)=PUT(LSYPCTR4,3.); SUBSTR(LSYPCOBT,4,1)='%'; END; ; /* Data Element Derivation (LSYTRSMN) */; FORMAT LSYTRSMN SCALE4.; LABEL LSYTRSMN="TRANSACTIONS PER MINUTE"; LSYTRSMN = .; DURMINS=(DURATION/60); IF DURMINS GT 0 THEN LSYTRSMN=LSYTRESC/DURMINS; ; /* Data Element Derivation (LSYTOTSN) */; FORMAT LSYTOTSN SCALE4.; LABEL LSYTOTSN="TOTAL CHARACTERS SENT"; LSYTOTSN = SUM(LSYNRCBS,LSYNRTBS); ; /* Data Element Derivation (LSYTOTRC) */; FORMAT LSYTOTRC SCALE4.; LABEL LSYTOTRC="TOTAL CHARACTERS RECEIVED"; LSYTOTRC = SUM(LSYNRCBR,LSYNRTBR); ; /* Data Element Derivation (LSYTOTTR) */; FORMAT LSYTOTTR SCALE4.; LABEL LSYTOTTR="TOTAL CHARACTERS TRANSMITTED"; LSYTOTTR = SUM(LSYNRCBR,LSYNRTBR,LSYNRCBS,LSYNRTBS); ; /* Data Element Derivation (LSYAVCHS) */; FORMAT LSYAVCHS SCALE4.; LABEL LSYAVCHS="AVERAGE CHARACTERS SENT"; LSYAVCHS = .; LSYNRFSR=SUM(LSYNRCBS,LSYNRTBS); IF LSYTRESC GT 0 THEN LSYAVCHS=LSYNRFSR/LSYTRESC; ; /* Data Element Derivation (LSYAVCHR) */; FORMAT LSYAVCHR SCALE4.; LABEL LSYAVCHR="AVERAGE CHARACTERS RECEIVED"; LSYAVCHR = .; LSYNRFRE=SUM(LSYNRCBR,LSYNRTBR); IF LSYTRESC NE 0 THEN LSYAVCHR=LSYNRFRE/LSYTRESC; ; /* Data Element Derivation (LSYAVCHT) */; FORMAT LSYAVCHT SCALE4.; LABEL LSYAVCHT="AVERAGE TOTAL CHARACTERS TRANSMITTED"; LSYAVCHT = .; LSYTOCTR=SUM(LSYNRCBS,LSYNRTBS,LSYNRCBR,LSYNRTBR); IF LSYTRESC NE 0 THEN LSYAVCHT=LSYTOCTR/LSYTRESC; ; /* Data Element Derivation (LSYAVPIU) */; FORMAT LSYAVPIU SCALE4.; LABEL LSYAVPIU="AVERAGE PIUS PER/RESPONSE"; LSYAVPIU = .; LSYNRPIU=SUM(LSYNRTPR,LSYNRTPS,LSYNRCPR,LSYNRCPS); IF LSYTRESC GT 0 THEN LSYAVPIU=LSYNRPIU/LSYTRESC; ; /* Data Element Derivation (LSYNRRNR) */; FORMAT LSYNRRNR SCALE4.; LABEL LSYNRRNR="NUMBER OF RESPONSES NOT IN RANGE"; LSYNRRNR = .; LSYNRRNR=(LSYTRESC-LSYNRROM); ;
Usage considerations
All cycles are summarized together as a data range rather than reporting by individual cycle or by year, month, day, and hour as other
MICS
reports do.

NetView Application Service/Workload Ranking Sample

1 (SNTLDA) DAILY APPLICATION RANKING BY ZONE FIRST 10 APPLICATIONS BY DESCENDING AVERAGE TOTAL RESPONSE TIME NETWORK ID: NETWORK1 SYSTEM ID: SYSA DATA RANGE: 23JULyy-01APRyy ZONE: 2 |-IDENTIFICATION--||------------------- RESPONSE INFORMATION --------------------|------------- WORKLOAD INFORMATION -------------| |DURATION(HH:MM) /||AVG RESPONSE MISSED RATE |- % MET OF -|-- TOTAL # --|--- TOTAL CHARS ---|----- AVG CHARS ----| PIUS /| |APPLICATION NAME ||RESP OBJECTIVE OBJ / MIN |SAMP TOTAL |RESP SAMPLES|SENT RECVD TRANS| SENT RECVD TRANS| RESP | ================= ===== ============ ===== ===== ==== ==== ===== ===== ===== ===== ===== ===== ===== ===== ====== 0:00 TVS2 1.65 85% < 5.0 0 2 100% 100% 2 2 0 0 0 0 0 0 0 0:01 H160X 1.48 85% < 5.0 9 5 100% 100% 11 2 0 0 0 0 0 0 0 0:01 H160Q8VC 0.49 85% < 5.0 11 11 100% 100% 12 1 0 0 0 0 0 0 0 0:00 H160Q4VC 0.31 85% < 5.0 7 26 100% 100% 8 1 0 0 0 0 0 0 0 0:00 HA99N . . 0 0 . . 0 1 4 76 80 0 0 0 0 0:00 HA99N . . 0 0 . . 0 13 36 779 815 0 0 0 0 0:00 HD93N . . 0 0 . . 0 1 0 55 55 0 0 0 0 0:00 HD93N002 . . 0 0 . . 0 1 0 56 56 0 0 0 0 0:01 H059CSM1 . . 0 0 . . 0 102 30K 1K 32K 0 0 0 0 0:00 H059CSM3 . . 0 0 . . 0 4 1K 67 1K 0 0 0 0 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=RTMAVTTM=AVERAGE TOTAL RESPONSE TIME RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=NSA/RTM 2

NetView Application Service/Workload Ranking  Sample 2

(SNTLDA) DAILY APPLICATION RANKING BY ZONE FIRST 10 APPLICATIONS BY DESCENDING AVERAGE TOTAL RESPONSE TIME NETWORK ID: NETWORK1 SYSTEM ID: SYSB DATA RANGE: 23JULyy-01APRyy ZONE: 1 |-IDENTIFICATION--||------------------- RESPONSE INFORMATION --------------------|------------- WORKLOAD INFORMATION -------------| |DURATION(HH:MM) /||AVG RESPONSE MISSED RATE |- % MET OF -|-- TOTAL # --|--- TOTAL CHARS ---|----- AVG CHARS ----| PIUS /| |APPLICATION NAME ||RESP OBJECTIVE OBJ / MIN |SAMP TOTAL |RESP SAMPLES|SENT RECVD TRANS| SENT RECVD TRANS| RESP | ================= ===== ============ ===== ===== ==== ==== ===== ===== ===== ===== ===== ===== ===== ===== ====== 0:30 P18IMSB 31.0 95% < 4.0 5 0 0% 40% 5 2 0 0 0 0 0 0 0 0:32 C41TS239 24.2 95% < 4.0 36 1 100% 97% 39 3 28K 946 29K 734 24 758 9 0:05 C41TS221 17.3 95% < 4.0 5 0 0% 80% 5 1 66K 1K 67K 13K 256 13K 81 0:15 C41TS205 11.0 95% < 4.0 23 1 0% 74% 23 1 0 0 0 0 0 0 0 0:45 C41TS138 10.9 95% < 4.0 3 0 67% 80% 5 3 0 0 0 0 0 0 0 0:15 C41TS276 8.86 95% < 4.0 33 2 0% 52% 33 2 12K 1K 13K 364 32 397 7 0:03 C41TS267 8.66 95% < 4.0 12 3 0% 83% 12 1 21K 727 22K 1K 60 1K 24 0:45 C41TS054 8.37 95% < 4.0 43 0 33% 82% 44 3 0 0 0 0 0 0 0 0:45 C41TS068 8.36 95% < 4.0 29 0 33% 80% 30 3 0 0 0 0 0 0 0 1:00 C41TS278 7.41 95% < 4.0 236 3 50% 97% 238 4 0 0 0 0 0 0 0 DATES=NONE, TIME=(00:00-24:00), NOTE:(K=THOUSANDS M=MILLIONS), RANKING=RTMAVTTM=AVERAGE TOTAL RESPONSE TIME RUN-DATE=Wed,Sep3,yy , TIMESPAN=DAYS, DBID=8, FILE=NSA/RTM