gprs query training .doc

8/10/2019 GPRS Query Training .doc

1/18

GPRS Query training

1


2/18

Objectives of the courseAfter completing this course, the delegate will be able to:

a) select the most appropriate query for the type of analysis

b) design the query in the most efficient manner

c) use queries for both structured and ad-hoc analysis methodsThis course steps through the different types of queries, teaching each method through

real world scenarios, from simple queries and building in complexity, to give engineersthe understanding and confidence to design their own queries from the minute the course

ends.

The examples in this course note should be followed, but it is not recommended that the

expressions are copied pasted into the !xpression "uilder, as hidden formattingcharacters from #$ %ord may also be copied, causing errors in how the event runs.

Course Pre-Requisites&elegates must have completed the 'latform Training before beginning this (uery

Training course. This course documentation provides screenshots based on "uild

.*+.** with specific settings enabled in Tools / 'references !ach '0 should be set inan identical manner. $ubsequent releases may include differences in averages or message

totals due to different features being introduced in the future.

Parameters Used1n 2igure it is possible to see 3 groups available for a 4'5$ analysis:

4'5$ &ata

&ata Testing.

Figure 1: GPRS Analysis parameters.

GPRS Data

2


3/18

GPRS L3

In this directory the information about the MS-SGSN procedures are displayed

Figure 2: GPRS L3 attributes.

Mobility Management!he attributes allo" the analysis of the mobility procedures# attach and detach P-!MSI allocation and reallocation routin$ area update net"or% parameters &MN'( M''( L)'( R)'( etc*

radio access capabilities

Session Management!he attributes allo" the analysis of the PdP conte+t procedures( accessed )PNsand related ,oS information

GPRS RM)'

In this directory there are all the attributes related to the RL'M)' layer !heseparameters are related to the multiple+in$ of pac%et data o.er the physical airinterface

Figure 3: GPRS RMAC attributes.

Dedicated radio link

!his contains radio messa$es information( !imin$ )d.ance( 'odin$ Scheme(Number of timeslots usedTBF Info!his contains information about !/0 &!emporary /loc% 0lo"* assi$nment and !/0number &!0I*Downlink Measurementse ha.e information about the radio lin% le.el &' alue* and /R &R+ ,ual*(collected from the Pac%et 4o"nlin% )c%no"led$ements

3


4/18

Data testing

!his directory includes the information collected on data ser.ices from the sin$ledri.e test tools and unified in a common terminolo$y !he follo"in$ sections definethe terminolo$y used in the SS product

Figure 4: Data esting attributes.

Session or Service) Session or Service starts "ith the phone connectin$ to the data ser.ices andends "ith the disconnection It normally contains a series of Tasks to be carried out

Sometimes a set of tas%s is iterated in se5uence

Task!his defines a sin$le user-defined process( "hich operates o.er a "ell definedperiod of time &ie it has a start and a stop*( such as an 0!P file do"nload( a PINGcommand( or a "eb pa$e do"nload )ll .endors ha.e a series of pre-defined tas%sand some allo" the user to define custom tas%s of their o"n!hese tas%s must be considered to be completely user-defined and are totallyindependent of the )pplication or Protocol&s* used to perform the tas%# In the same

6


5/18

"ay that the content of a .oice call is specified by the user and is independent of themechanisms used to transmit the information

Figure !: Sessi"ns an# as$s.

Application)t the most $eneral le.el( an application is a piece of soft"are that the user runs totransfer data across the net"or% In practice( it "ill usually be somethin$ li%e an 0!P

client or a eb bro"ser

Protocol) !as% usually uses a sin$le protocol &e$ an 0!P client may use 74P* andthere"ill usually be a mappin$ bet"een an )pplication and a specific Protocol &e$ aPING pro$ram "ill use I'MP*In $eneral( attributes are measured at the application layer &e$ )pplication!hrou$hput* and at different layers in the protocol stac% &e$ IP !hrou$hput*Lo$$in$ tools may pro.ide attributes from different layers in the protocol stac% &e$74P8!hrou$hput* e can use a unified attribute that allo"s measurements atdifferent layers to be displayed in a consistent "ay "ithout ha.in$ to ha.e separateattributes for each one - ie instead of#

)P84elay87L 0!P8!hrou$hput84L 9!!P8/ytes87L PING8R!!

e ha.e#

)pp84elay)pp8!hrou$hput84L)pp8/ytes87L)pp8R!!

and# !as%8)pp8Protocol !as%8Name

!he attribute !as%8)pp8Protocol is an enumeration for !'P( 74P( I'MP etc and isderi.ed from the standard ports used for these protocols !as%8name is auserspecified identifier for the !as% "hich could be anythin$ e$ Lar$eeb(Small0!P( etc

:


6/18

!he 4ata !estin$ attributes are $rouped in : sets#

Application Measurements!hese are the reported ;instantaneous< .alues e$ instantaneous throu$hputs( errorrates etc( measured at the )pplication layeronnection

)ttributes that relates to the data session are contained hereTask Settings

)ttributes that are related to the specific tas% e$ the !as% I4( !as% name &userspecified*( etcTask SummaryMeasurements reported at the end of a tas% = or calculated from instantaneousmeasurements and reported at the end e$( ma+mina.era$e throu$hput durin$ thetas%

Note related to the data collection# it is ob.iously important to test all applicationprotocols o.er GPRS &0!P( 9!!P( SM!P(P>P3 etc* but $enerally the continuous

nature of 0!P ma%e it the most appropriate for dri.e testin$ as data flo" iscontinuous

Query Design

Overa GPRS !naysis crosstab query6ogfile: 4'5$ !xample .dt7ame: 8verall 4'5$ Analysis

Aim: To generate 9'1s statistics to be calculated on a file or a superstream of more files.

&efinition:4enerate an overall crosstab query to calculate the following 9'1s:

7umber of Attach 5equest 7umber of Attach Accept

7umber of Attach Abort

7umber of '&' 5equest

7umber of '&' Accept

7umber of '&' Abort

7umber of Application $uccess

7umber of Application 2ailures

7umber of 5A; 5equest

7umber of 5A; $uccess

7umber of 5A; 2ailures.

'rocedure:) 6oad file 4'5$ !xample .dt3) 8pen the Analysis #anager and select the 0rosstab query wi


7/18

Figure %: De&initi"n "& t'e #imensi"n C"nstant.

) 7ow add the list of statistics described at the beginning of the exercise, following the

specification at Table :

Name Method Expression Format Filter

7umber ofAttach

5equest

0ount 0ount 4'5$>##>#sg>Type ??

7umber of

Attach

$uccess

0ount 0ount 4'5$>##>#sg>Type ?? 3

7umber of

Attach Abort


7umber of'&' 5equest 0ount 0ount 4'5$>$#>#sg>Type ?? =

7umber of

'&' $uccess

0ount 0ount 4'5$>$#>#sg>Type ?? ==

7umber of

'&' Abort

0ount 0ount 4'5$>$#>#sg>Type ?? =

7umber of

Application

0ount !vent>Tas@>!n

d

0ount

@


8/18

$uccess

7umber of

Application

2ailure

0ount !vent>Tas@>2ai

l

0ount

7umber of

5A;5equest


7umber of5A; $uccess

0ount 0ount 4'5$>##>#sg>Type ?? B

7umber of

5A; Abort


able 1: Statisti(s t" a## t" t'e )uery.

=) At the end we can display the results in the $tatistics !xplorer as in 2igure

Figure *: Results #isplaye# "n t'e Statisti(s +,pl"rer.

) 1n order to ma@e the query faster and then more efficient, we can add a 4lobal 2ilter

in order to s@ip all the messages that the query does not need: we are going to ta@e in

account messages with attribute !vent>Tas@>!nd, !vent>Tas@>2ail,4'5$>##>#sg>Type and 4'5$>$#>#sg>Type valid. Then clic@ on the4lobal 2ilter button as shown in 2igure :

A


9/18

Figure -: Cli($ "n t'e Filter butt"n.

) The !xpression of the filter needs a new function, isvalid()that chec@ if that attribute

is set with a valid value at that message. 1n 2igure B, you can see the definition of thefilter:

B


10/18

Figure : De&initi"n "& t'e Gl"bal Filter.

B) 1t is possible to chec@ the query results did not change as you can see in 2igure *:there is only important difference: before the query needed to be executed for all

the messages in the file C33*), now only for a small se of them C+*)

Figure 1/: Same 0alues &"r t'e statisti(s but less messages in0"l0e# FAS+R )uery t" be

e,e(ute#.

GPRS R!U !naysis crosstab query6ogfile: 4'5$ !xample .dt

1C


11/18

7ame: 4'5$ 5A; Analysis

Aim and &efinition: 2or any message that is related to 5A; procedure, display the type

of message, the $erving 01 and the delta time from the previous 5A; message.

'rocedure:

) 6oad file 4'5$ !xample .dt3) 8pen the Analysis #anager and select the 0rosstab query wi


12/18

Figure 12: Gl"bal Filter.

=) %e need + statistics as displayed in Table 3

Name Method Expression Format

5A;

#essage

6ast

Dalue

4'5$>##>#sg>Type 0ount

$erv01 6ast

Dalue

$tateC$erv01) 4$# 01

Time&elta 6ast

Dalue

Time -

defaultCprev>time>whereCC4'5$>##>#

sg>Type/?) A7&C4'5$>##>#sg>TypeE?)),*)

Time

able 2: Statisti(s t" a##.

) %e can display on the $tatistics !xplorer the results of the query:

12


13/18

Figure 13: RA Analysis Results.

) %e have a list of 5A; 5equests: we can see they are grouped by with a time

difference of secs about. !ven if we dont have any 5A; 5eFect, we can figureout we have + 5A; 2ailures.

Task Analysis rosstab !uery

6ogfile: 4'5$ !xample .dt and 4'5$ !xample 3.dt, superstreamed on Time.7ame: Tas@ Analysis

Aim: 2or any tas@ display the related information.

&efinition:0reate a crosstab query dimensioned by Tas@1d Tas@ ApplicationType 2ile7ame and display for any Tas@

Tas@ Type,

#ean App Throughput ;6

#ean App Throughput &6

Total "ytes ;ploaded

Total "ytes &ownloaded

Tas@ &uration

Tas@ 2ailures

Tas@ 2ailure 0ause.

13


14/18

'rocedure:

) 4'5$ !xample .dt and 4'5$ !xample 3.dt and superstream on Time3) 8pen the Analysis #anager and select the 0rosstab query wi


15/18

'&' 5eq.

&6 0-value

&6 660 Throughput

;6 660 Throughput

&6 "6!5

;6 5etransmissions

&6>0$>Actual

;6>0$>Actual.

'rocedure:) 4'5$ !xample .dt and 4'5$ !xample 3.dt and superstream on Time

3) 8pen the Analysis #anager and select the 0rosstab query wi$#>#sg>

Type ?? =

&6 0-value #ean

C6inear)

5#A0>0>Dalue 4$#

5x6ev

&6 660

Throughput

#ean 660>Throughput>&6 4$# 4'5$

"it 5ate

;6 660

Throughput

#ean 660>Throughput>;6 4$# 4'5$

"it 5ate

&6 "6!5 #ean 560>&6>"6!5 'ercentage

&6>0$>Actual

#ode 5#A0>&6>0$>Actual 4$# 4'5$5#A0

000

;6>0$>Actu

al

#ode 5#A0>;6>0$>Actual 4$# 4'5$

5#A0

000

able 3: Statisti(s t" a##.

=) 1n the $tatistics !xplorer it is possible to have a general picture for any $ite.

1:


16/18

"aied #as$ !naysis event query6ogfile: 4'5$ !xample .dt and 4'5$ !xample 3.dt, superstreamed on Time.7ame: 2ailed Tas@ Analysis $tats

Aim: To analy


17/18

Figure 34: M"#i&i(ati"n "& t'e Dimensi"n +0entime.

=) 0reate the following statistics:

Name Method Expression Format

Avg5#A0>0>Dalue

#eanC6inear)

5#A0>0>Dalue 4$# 5x6ev

Avg 5x (ual #ean

C5x(ual)

5#A0>5x(ual 4$#

5x(ual

'oor $ignal 'ercent

True

5#A0>0>Dalue E? - 'ercentage

Dariable $ignal 'ercent

True

5#A0>$ign>Dar / 3 'ercentage

1nterference 'ercent

True

5#A0>5x(ual /? A7&

5#A0>0>Dalue / -

'ercentage

!xcessive 'ower

5eduction

'ercent

True

5#A0>'ower>5eduction /?3 'ercentage

7o pac@et

Timeslots

'ercent

True

5#A0>&6>7umTimeslots>;sed>Actual

?? *

'ercentage

&istant $erving0ell

'ercentTrue

5#A0>TimingAdvance1ndex / * 'ercentage

6ow "andwith 'ercentTrue

* E5#A0>&6>7umTimeslots>;sed>Actual

E? 3

'ercentage

0oGAdFacent

0hannel

allocations

betweenneighbors

'ercent

True

CCCCCabsCstateC$erv"00H)-

defaultC7bor"00HI*J,*))E3)) K

CCabsCstateC$erv"00H)-

defaultC7bor"00HIJ,*))E3)) KCCabsCstateC$erv"00H)-

defaultC7bor"00HI3J,*))E3)) K

CCabsCstateC$erv"00H)-defaultC7bor"00HI+J,*))E3)) K

CCabsCstateC$erv"00H)-

defaultC7bor"00HIJ,*))E3)) KCCabsCstateC$erv"00H)-

defaultC7bor"00HIJ,*))E3)))/*) A7&

CdefaultCstateC5#A0>0>Dalue),-*)/-))

'ercentage

5eported Tas@2ailure 0ause

6astDalue

Tas@>2ailure>0ause $tring

$erv "00H 6ast

Dalue

stateC$erv"00H) 4$#

A5207

$erv 01 6ast

Dalue

$tateC$erv01) 4$# 01

able 4: Statisti(s t" a## t" t'e )uery.

1@


18/18

) &isplay the results in the $tatistics !xplorer:

1A

gprs query training .doc

Documents