# SGS-VLR Schema Statistics

The SGS-VLR schema provides operational statistics that can be used for monitoring and troubleshooting SGs connections on a per-VLR basis for the following products: MME.
This schema provides the following types of statistics:

- Counter: A counter records incremental data cumulatively and rolls over when the counter limit is reached. All counter statistics are cumulative and reset only by one of the following methods: roll-over when limit is reached, after a system restart, or after a clear command is performed. The limit depends upon the data type.
- Gauge: A gauge statistic indicates a single value; a snapshot representation of a single point in time within a defined time frame. The gauge changes to a new value with each snapshot though a value may repeat from one period to the next. The limit depends upon the data type.
- Information: This type of statistic provides information, often intended to differentiate sets of statistics; for example, a VPN name or IP address. The type of information provided depends upon the data type.

The data type defines the format of the data for the value provided by the statistic. The following data types are used in statistics for this schema:

- Int32/Int64: An integer, either 32-bit or 64-bit: For statistics with the Int32 data type, the roll-over to zero limit is 4,294,967,295. For statistics with the Int64 data type, the roll-over to zero limit is 18,446,744,073,709,551,615.
- Float: A numeric value that can be represented fractionally; for example, 1.345.
- String: A series of ASCII alphanumeric characters in a single grouping, usually pre-configured.

IMPORTANT:

Unless otherwise indicated, all statistics are counters and all statistics are standards-based.

Key Variables: Every schema has some variables which are typically referred to as 'key variables'. These key variables provide index markers to identify which object the statistics apply to. For example, in the card schema, the card number (variable %card%) uniquely identifies a card. For an HA service, the keys would be "%vpnname%" plus "%servname%", as the combination uniquely identifies an HA service. So, in a given measurement interval, one row of statistics will be generated per unique key. The schema keys are identified in the Description section of the table.
Table 1. Bulk Statistics Variables in the SGS-VLR Schema

Variable | Description | Data Type
--- | --- | ---
vpnname | The name of the context configured on the system that is currently facilitating the SGs configuration. This is a key variable. Type: Information | String
vpnid | The identification number of the context configured on the system that is currently facilitating the SGs configuration. This is an internal reference number. This is a key variable. Type: Information | Int32
servname | The name of the service for which SGs statistics are being displayed. This is a key variable. Type: Information | String
servid | The identification number of the service configured on the system that is currently facilitating MME subscriber sessions. This is an internal reference number. This is a key variable. Type: Information | Int32
vlrname | The name of the specific VLR for which statistics are being displayed. This is a key variable. Type: Information | String
pag-req-tx | The total number of paging request messages transmitted. Type: Counter | Int32
pag-req-retx | The total number of paging request messages retransmitted. Type: Counter | Int32
pag-req-rx | The total number of paging request messages received. Type: Counter | Int32
pag-rej-tx | The total number of paging reject messages transmitted. Type: Counter | Int32
pag-rej-retx | The total number of paging reject messages retransmitted. Type: Counter | Int32
pag-rej-rx | The total number of paging reject messages received. Type: Counter | Int32
service-req-tx | The total number of service request messages transmitted. Type: Counter | Int32
service-req-retx | The total number of service request messages retransmitted. Type: Counter | Int32
service-req-rx | The total number of service request messages received. Type: Counter | Int32
dl-ud-tx | The total number of downlink unit data messages transmitted. Type: Counter | Int32
dl-ud-retx | The total number of downlink unit data messages retransmitted. Type: Counter | Int32
dl-ud-rx | The total number of downlink unit data messages received. Type: Counter | Int32
ul-ud-tx | The total number of uplink unit data messages transmitted. Type: Counter | Int32
ul-ud-retx | The total number of uplink unit data messages retransmitted. Type: Counter | Int32
ul-ud-rx | The total number of uplink unit data messages received. Type: Counter | Int32
localupd-req-tx | The total number of location update request messages transmitted. Type: Counter | Int32
localupd-req-retx | The total number of location update request messages retransmitted. Type: Counter | Int32
localupd-req-rx | The total number of location update request messages received. Type: Counter | Int32
localupd-accept-tx | The total number of location update accept messages transmitted. Type: Counter | Int32
localupd-accept-retx | The total number of location update accept messages retransmitted. Type: Counter | Int32
localupd-accept-rx | The total number of location update accept messages received. Type: Counter | Int32
localupd-rej-tx | The total number of location update reject messages transmitted. Type: Counter | Int32
localupd-rej-retx | The total number of location update reject messages retransmitted. Type: Counter | Int32
localupd-rej-rx | The total number of location update reject messages received. Type: Counter | Int32
tmsi-reloc-tx | The total number of TMSI reallocation complete messages transmitted. Type: Counter | Int32
tmsi-reloc-retx | The total number of TMSI reallocation complete messages retransmitted. Type: Counter | Int32
tmsi-reloc-rx | The total number of TMSI reallocation complete messages received. Type: Counter | Int32
alert-req-tx | The total number of alert request messages transmitted. Type: Counter | Int32
alert-req-retx | The total number of alert request messages retransmitted. Type: Counter | Int32
alert-req-rx | The total number of alert request messages received. Type: Counter | Int32
alert-ack-tx | The total number of alert ack messages transmitted. Type: Counter | Int32
alert-ack-retx | The total number of alert ack messages retransmitted. Type: Counter | Int32
alert-ack-rx | The total number of alert ack messages received. Type: Counter | Int32
alert-rej-tx | The total number of alert reject messages transmitted. Type: Counter | Int32
alert-rej-retx | The total number of alert reject messages retransmitted. Type: Counter | Int32
alert-rej-rx | The total number of alert reject messages. Type: Counter | Int32
ue-actind-tx | The total number of UE activity indication messages transmitted. Type: Counter | Int32
ue-actind-retx | The total number of UE activity indication messages retransmitted. Type: Counter | Int32
ue-actind-rx | The total number of UE activity indication messages received. Type: Counter | Int32
eps-detind-tx | The total number of EPS detach indication messages transmitted. Type: Counter | Int32
eps-detind-retx | The total number of EPS detach indication messages retransmitted. Type: Counter | Int32
eps-detind-rx | The total number of EPS detach indication messages received. Type: Counter | Int32
eps-detack-tx | The total number of EPS detach ack messages transmitted. Type: Counter | Int32
eps-detack-retx | The total number of EPS detach ack messages retransmitted. Type: Counter | Int32
eps-detack-rx | The total number of EPS detach ack messages received. Type: Counter | Int32
imsi-detind-tx | The total number of IMSI detach indication messages transmitted. Type: Counter | Int32
imsi-detind-retx | The total number of IMSI detach indication messages retransmitted. Type: Counter | Int32
imsi-detind-rx | The total number of IMSI detach indication messages received. Type: Counter | Int32
imsi-detack-tx | The total number of IMSI detach ack messages transmitted. Type: Counter | Int32
imsi-detack-retx | The total number of IMSI detach ack messages retransmitted. Type: Counter | Int32
imsi-detack-rx | The total number of IMSI detach ack messages received. Type: Counter | Int32
reset-ind-tx | The total number of reset indication messages transmitted. Type: Counter | Int32
reset-ind-retx | The total number of reset indication messages retransmitted. Type: Counter | Int32
reset-ind-rx | The total number of reset indication messages received. Type: Counter | Int32
reset-ack-tx | The total number of reset ack messages received. Type: Counter | Int32
reset-ack-retx | The total number of reset ack messages retransmitted. Type: Counter | Int32
reset-ack-rx | The total number of reset ack messages received. Type: Counter | Int32
mm-inforeq-tx | The total number of MM information request messages transmitted. Type: Counter | Int32
mm-inforeq-retx | The total number of MM information request messages retransmitted. Type: Counter | Int32
mm-inforeq-rx | The total number of MM information request messages received. Type: Counter | Int32
rel-req-tx | The total number of release request messages transmitted. Type: Counter | Int32
rel-req-retx | The total number of release request messages retransmitted. Type: Counter | Int32
rel-req-rx | The total number of release request messages received. Type: Counter | Int32
status-tx | The total number of status messages transmitted. Type: Counter | Int32
status-retx | The total number of status messages retransmitted. Type: Counter | Int32
status-rx | The total number of status messages received. Type: Counter | Int32
ue-unreach-tx | The total number of UE unreachable messages transmitted. Type: Counter | Int32
ue-unreach-retx | The total number of UE unreachable messages retransmitted. Type: Counter | Int32
ue-unreach-rx | The total number of UE unreachable messages received. Type: Counter | Int32
unk-msg-tx | The total number of unknown messages transmitted. Type: Counter | Int32
unk-msg-retx | The total number of unknown messages retransmitted. Type: Counter | Int32
unk-msg-rx | The total number of unknown messages received. Type: Counter | Int32
offload-count | The current number of UEs marked for VLR offload as a result of the use of ‘sgs offload’ command. Type: Gauge | Int32
failure-count | The current number of UEs the MME is attempting to detach due a VLR becoming unavailable. Type: Gauge | Int32
recover-count | The number of Circuit Switched Fall Back (SMS-only) UEs which the MME is currently attempting to recover due to a VLR becoming unavailable. Type: Gauge | Int32
offload-total | The total number of UEs offloaded as a result of the use of ‘sgs offload’ command. Type: Counter | Int32
failure-total | The total number of UEs the MME has detached due a VLR becoming unavailable. Type: Counter | Int32
recover-total | The total number of Circuit Switched Fall Back (SMS-only) UEs which the MME has recovered as a result of a VLR becoming unavailable. Type: Counter | Int32
IMPORTANT: For information on statistics that are common to all schema see the Statistics and Counters Overview chapter.