|
|
|
INTENDED USE:
To rank application workloads in ascending or descending
order based on response times or character volumes. The
user chooses the number of applications ranked, the order
of ranking, and the variable used to rank on. The 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 CA MICS reports do.
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 (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
Figure 3-
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |