sgsn / GGSn KPI's

[deep123]

Pl share some documents on the sgsn KPi's///

Thanks in Advance

[gencerali]

Here is Basic SGSN KPI Fromulas
For E*******&Huawei SGSN

HUAWEI SGSN Formulas
2G Attach Success Rate (%)

100- PERCENT (GREATEST ( C117454513
- C117454514
- C117454515
- C117454516
- C117454517
- C117454518
- C117454519
- C117454525
- C117454526
- C117454527
- C117454528
- C117454529
- C117454530
- C117454531
- C117454532
- C117454535
- C117454536
- C117454537
- C117454538
- C117454539
- C117454540
- C117454541
- C117454545
- C117454546
- C117454547
- C117454548
- C117454549
- C117454417,
0),
(C117454513 - C117454415) )

Authentication Success Rate%

PERCENT( (C117454926)
+ (C117457026)
+ (C117454928)
+ (C117457028),
(C117454925)
+ (C117457025)
+ (C117454927)
+ (C117457027))





3G Paging Success Rate(%)

PERCENT((C117457114-C117457115),(C117457114)) "3G Paging Succ%",
C117457114 "Paging Reqs",
C117457115 "Paging None Response",
C117457116 "Paging Reqs by GERAN",
C117457117 "Paging Resp. By 2G RAU",
C117457118 "Paging Resp. By Service Reqs"
2G Paging Success Rate(%)

PERCENT((C117455116-C117455117),(C117455116)) "2G Paging Succ%",
C117455116 "Paging Reqs",
C117455117 "Paging Fail"

2G Inter SGSN RAU Success Rate(%)

100-PERCENT((C117454813-C117454814-
C117454815-C117454816-
C117454817-C117454818-
C117454819-C117454826-
C117454827-C117454828-
C117454829-C117454842-
C117454820-C117454843-
C117454830
),(C117454813)) "2G Inter RAU Succ%",
ROUND((C117454814)/(C117454813),2)*100 "2G Inter RAU SuccHUAWEI%",
C117454813 "Inter RAU Reqs",
C117454814 "Inter RAU Succ",
C117454815 "Illegal MS",
C117454816 "LA not allowed",
C117454817 "roaming not allowed in LA",
C117454818 "İllegalME",
C117454819 "GPRS service not allowed",
C117454820 "ImplicityDetached",
C117454821 "protocol error",
C117454822 "Gr fail",
C117454823 "Ge fail",
C117454826 "Comb.illegal MS",
C117454827 "Comb.LA not allowed",
C117454828 "Comb.illegal ME",
C117454829 "Comb.GPRS service not allowed",
C117454830 "Comb.ImplicityDetached",
C117454831 "Comb.protocol error",
C117454832 "Comb.Gr fail",
C117454833 "Comb.Ge fail",
C117454838 "GPRS not allowed in PLMN",
C117454839 "No suitable Cells in LA",
C117454840 "Comb.GPRS not allowed",
C117454841 "Comb.NosuitableCellsLA",
C117454842 "MsIdentitynotderived",
C117454843 "Comb.MsIdentitynotderived"


3G Inter SGSN RAU Success Rate(%)

100-PERCENT((C117456913-C117456914-C117456915-
C117456916-C117456917-C117456918-
C117456919-C117456920-C117456926-
C117456927-C117456928-C117456929-C117456930-
C117456937-C117456939-C117456941-C117456942),(C117456913)) "3G Inter RAU Succ%",
C117456913 "INTER RAU Request",
C117456914 "INTER RAU Succ",
C117456915 "Illegal MS",
C117456916 "LA not allowed",
C117456917 "roaming not allowed in LA",
C117456918 "İllegalME",
C117456919 "GPRS service not allowed",
C117456920 "ImplicityDetached",
C117456921 "protocol error",
C117456922 "Gr fail",
C117456923 "Ge fail",
C117456926 "Comb.illegal MS",
C117456927 "Comb.LA not allowed",
C117456928 "Comb.illegal ME",
C117456929 "Comb.GPRS service not allowed",
C117456930 "Comb.ImplicityDetached",
C117456931 "Comb.protocol error",
C117456932 "Comb.Gr fail",
C117456933 "Comb.Ge fail",
C117456937 "GPRS not allowed in PLMN",
C117456938 "No suitable Cells in LA",
C117456939 "Comb.GPRS not allowed",
C117456940 "Comb.NosuitableCellsLA",
C117456941 "MsIdentitynotderived",
C117456942 "Comb.MsIdentitynotderived"

2G Intra SGSN RAU Success Rate(%)

PERCENT ( ( C117454713
- C117454714
- C117454715
- C117454716
- C117454717
- C117454718
- C117454724
- C117454725
- C117454726
),
(C117454713) ) "2G Intra RAU Succ%",
C117454713 "Intra RAU Reqs",
C117454714 "Intra RAU Succ",
C117454715 "Illegal MS",
C117454716 "LA not allowed",
C117454717 "RoamingNotAllowedinLA",
C117454718 "ImplicityDetached",
C117454719 "protocol error",
C117454720 "Gr fail",
C117454721 "Ge fail",
C117454724 "Comb.illegal MS",
C117454725 "Comb.LA not allowed",
C117454726 "Comb.Roam.NotAllowdinLA",
C117454727 "Comb.ImplicityDetached",
C117454728 "Comb.protocol error",
C117454729 "Comb.Gr fail",
C117454730 "Comb.Ge fail",
C117454734 "No suitableCellsinLA",
C117454735 "Comb.No suitableCellsinLA",
C117454738 "PeriodicIllegalMS",
C117454739 "PeriodicLAnotallowed",
C117454740 "PeriodicRoamingNotAllowedinLA",
C117454741 "PeriodicImplicityDetached",
C117454742 "Periodicprotocolerror",
C117454743 "Periodic Gr fail",
C117454744 "Periodic Ge fail",
C117454745 "PeriodicNosuitableCellsinLA"
3G Intra SGSN RAU Success Rate(%)

100-(PERCENT((C117456813-C117456814-C117456815-C117456816-C117456817),(C117456813),2)) "3G Intra RAU Succ%",
C117456813 "Intra RAU Reqs",
C117456814 "INTRa RAU Succ",
C117456815 "Illegal MS",
C117456816 "LA not allowed",
C117456817 "ImplicityDetached",
C117456818 "protocol error",
C117456819 "Gr fail",
C117456820 "Ge fail",
C117456823 "Comb.illegal MS",
C117456824 "Comb.LA not allowed",
C117456825 "Comb.ImplicityDetached",
C117456826 "Comb.protocol error",
C117456827 "Comb.Gr fail",
C117456828 "Comb.Ge fail",
C117456832 "NosuitableCellsinLA",
C117456833 "Comb.Nosuit.CellsinLA",
C117456834 "PeriodicRAURequests",
C117456835 "PeriodicRAUsuccess",
C117456836 "PeriodicIllegalMS",
C117456837 "PeriodicLAnotallwd",
C117456838 "PeriodicImplctyDetchd",
C117456839 "Periodicprotoc.err",
C117456840 "PeriodicGr fail",
C117456841 "PeriodicGe fail",
C117456842 "PeriodNoSuit.CellinLA"

3G Intra SGSN Periodic RAU Success Rate(%)

100-(PERCENT((C117456834-C117456835-C117456836-C117456837-C117456838),(C117456834),2)) "3G Intra Periodic RAU Succ%"


2G Paging Success Rate(%)


PERCENT((C117455116-C117455117),(C117455116)) "2G Paging Succ%",
C117455116 "Paging Reqs",
C117455117 "Paging Fail"

Process Load (%)

C117462021 " AVG CPU occupation ",
C117462022 " AVG message cache area util ",
C117462023 " AVG dynamic memory util ",
C117462024 " CPU overload times",
C117462025 " CPU overload duration",
C117462026 " CPU congestion times",
C117462027 " CPU congestion duration",
C117462028 " max CPU occupation ",
C117462029 "Absolutely AVG CPU occupation ",
C117462030 "Absolutely max CPU occupation "

3G User Statistics(#)

C117457217 "Realtime User STDBY",
C117457218 "Avg User STDBY",
C117457219 "Max User STDBY",
C117457220 "Total Attach Duration",
C117457222 "Avg attach Duration",
C117457223 "Realtime User STDBY PLMN",
C117457224 "Avg User STDBY PLMN",
C117457225 "Max User STDBY PLMN",
C117457226 "Realtime User READY PLMN",
C117457227 "Avg User READY PLMN",
C117457228 "Max User READY PLMN"

3G Attach Success Rate(%)


100-percent(greatest(C117456613-C117456614-C117456615-
C117456616-C117456617-C117456618-
C117456624-C117456625-
C117456626-C117456629-C117456635-
C117456636-C117456637-C117456638-
C117456642-C117456643-C117456644-
C117456645-C117456646-C117456647-C117456517,0),(C117456613-C117456515),2)


2G PDP Context Success Rate(%)


100-PERCENT((C117458513-C117458514-
C117458524-C117458525-
C117458526-C117458542-C117458527-C117458528),(C117458513),2)
3G PDP Context Success Rate(%)

100-PERCENT((C117459413-C117459414 -
C117459428-C117459429-
C117459430-C117459431-C117459432-C117459441
),(C117459413),2)


2G PDP Context Success Rate(%)- Hedef


100-PERCENT((C117458513-C117458514-
C117458524-C117458525-
C117458526-C117458542-C117458527-C117458528-C117458522),(C117458513),2)
3G PDP Context Success Rate(%)- Hedef

100-PERCENT((C117459413-C117459414-C117459422-
C117459428-C117459429-
C117459430-C117459431-C117459432-C117459441
),(C117459413),2)
3G Inter SGSN RAU E*******- Hedef

100-PERCENT(SUM(ATTINTERSGSNRAUPDATEUMTS)-SUM(SUCCINTERSGSNRAUPDATEUMTS)-(SUM(MMUNSUCCINTERSGSNRAUCC14U)+SUM(MMUNSUCCINTERSGSNRAUCC9U)+SUM(MMUNSUCCINTERSGSNRAUCC10U)),
SUM(ATTINTERSGSNRAUPDATEUMTS),2)



2G Inter SGSN RAU E*******-
SUM(ATTINTERSGSNRAUPDATE) - SUM(SUCCINTERSGSNRAUPDATE) - (SUM(MMUNSUCCINTERSGSNRAUCC14G) + SUM (MMUNSUCCINTERSGSNRAUCC9G)+SUM(MMUNSUCCINTERSGSNRAUCC10G))
SUM(ATTINTERSGSNRAUPDATE)


2G PDP Context Success E*******-
100- PERCENT((DISCARDEDSESSIONMGMNT+GPRSSMSGSNUNSUCCACTIVATIONS)-
(SMUNSUCCACTPDPCTXTCC26G+SMUNSUCCACTPDPCTXTCC27_28G+SMUNSUCCACTPDPCTXTCC29G+SMUNSUCCACTPDPCTXTCC32_33G),
(SMATTACTPDPCTXTG)+(DISCARDEDSESSIONMGMNT))
3G PDP Context Success E*******-
100-PERCENT((SMATTACTPDPCTXTU-SMSUCCACTPDPCTXTU)-(SMUNSUCCACTPDPCTXTCC26u+SMUNSUCCACTPDPCTXTCC27_28U+SMUNSUCCACTPDPCTXTCC29U+SMUNSUCCACTPDPCTXTCC32_33U),
(SMATTACTPDPCTXTU))


2G Attach Success E*******-

100- PERCENT(((DISCARDEDGPRSATCH)+(DISCARDEDCOMBIATCH)+(GPRSMMSGSNUNSUCCATCHREQUESTS)) -((MMUNSUCCATCHCC7G)+(MMUNSUCCATCHCC8G)+(MMUNSUCCATCHCC11G)+(MMUNSUCCATCHCC13G)+(MMUNSUCCATCHCC14G)+(MMUNSUCCATCHCC15G)),
((DISCARDEDGPRSATCH)+(DISCARDEDCOMBIATCH)+(ATTCOMBIATCH)+(ATTGPRSATCH)+(ATTIMSIATCH))))

3G Attach Success E*******-

100-PERCENT((UNSUCCGPRSATCHUMTS)- (MMUNSUCCATCHCC7U+MMUNSUCCATCHCC8U+MMUNSUCCATCHCC11U+MMUNSUCCATCHCC13U+MMUNSUCCATCHCC14U+MMUNSUCCATCHCC15U),
(ATTGPRSATCHUMTS))

[aldiden45]

old document about E// SGSN. It would be good if someone has the Alex files for SGSN/GGSN for E// or the ones from NSN.

rgds
Aldi