Topic Last Modified: 2012-10-02

Each record represents one audio stream. One audio media line usually contains two audio streams.

Column Data Type Key/Index Details

ConferenceDateTime

datetime

Primary

Referenced from the MediaLine Table.

SessionSeq

int

Primary

Referenced from the MediaLine Table.

MediaLineLabel

tinyint

Primary

Referenced from the MediaLine Table.

StreamID

int

Primary

Unique ID within a media line.

JitterInterArrival

int

 

Average network jitter from Real Time Control Protocol (RTCP) statistics.

JitterInterArrivalMax

int

 

Maximum network jitter during the call.

PacketLossRate

decimal(5,4)

 

Average packet loss rate during the call.

PacketLossRateMax

decimal(5,4)

 

Maximum packet loss observed during the call.

BurstDensity

decimal(9,4)

 

Average density of packet Loss during bursts of losses during the call.

BurstDuration

int

 

Average duration of packet loss during bursts of losses during the call.

BurstGapDensity

decimal(9,4)

 

Average density of packet loss during gaps between bursts of packet loss.

BurstGapDuration

int

 

Average duration of gaps between bursts of packet loss.

PacketUtilization

Int

 

Packet count for the audio stream.

BandwidthEst

Int

 

Bandwidth estimates for the audio stream.

DegradationAvg

decimal(3,2)

 

Network MOS Degradation for the whole call. Range is 0.0 to 5.0. This metric shows the amount the Network MOS was reduced because of jitter and packet loss. For acceptable quality it should less than 0.5.

DegradationMax

decimal(3,2)

 

Maximum Network MOS degradation during the call.

DegradationJitterAvg

decimal(3,2)

 

Network MOS degradation caused by jitter.

DegradationPacketLossAvg

decimal(3,2)

 

Network MOS degradation caused by packet loss.

AudioPayloadDescription

int

Foreign

The audio Codec used for the call, referenced from PayloadDescription Table.

AudioSampleRate

int

 

Sampling rate for the audio stream.

RoundTrip

int

 

Round trip time from RTCP statistics. For acceptable quality this should be less than 100ms.

RoundTripMax

int

 

Maximum round trip time for the audio stream.

OverallAvgNetworkMOS

decimal(3,2)

 

Average wideband Network MOS for the call. This metric depends on the packet loss, jitter, and codec used. Range is [1.0 to 5.0].

OverallMinNetworkMOS

decimal(3,2)

 

The minimum wideband Network MOS for the call.

SendListenMOS

decimal(3,2)

 

The average predicted wideband Listening MOS score for audio sent, including speech level, noise level and capture device characteristics.

SendListenMOSMin

decimal(3,2)

 

The minimum SendListenMOS for the call.

RecvListenMOS

decimal(3,2)

 

The average predicted wideband Listening MOS score for audio received from the network including speech level, noise level, codec, network conditions and capture device characteristics.

RecvListenMOSMin

decimal(3,2)

 

The minimum RecvListenMOS for the call.

AudioFECUsed

bit

Flag indicating if audio FEC was used for the call.

RatioConcealedSamplesAvg

decimal(5,2)

Average ratio of concealed samples generated by audio healing to typical samples.

RatioStretchedSamplesAvg

decimal(5,2)

Average ratio of stretched samples generated by audio healing to typical samples.

RatioCompressedSamplesAvg

decimal(5,2)

Average ratio of compressed samples generated by audio healing to typical samples.

Inbound

bit

 

Stream data on receiver side is received.

Outbound

bit

 

Stream data on sender side is received.

SenderIsCallerPAI

bit

 

1 means the stream direction is from the caller to the callee.

0 means the stream direction is from the callee to the caller.

JitterInterArrivalSD

float

Standard deviation for jitter arrival times.

This column was introduced in Microsoft Lync Server 2013.

ConcealRatioMax

float

Maximum ratio of packets concealed by the healer.

This column was introduced in Microsoft Lync Server 2013.

ConcealRatioSD

float

Standard deviation for the ratio of packets concealed by the healer.

This column was introduced in Microsoft Lync Server 2013.

HealerPacketDropRatio

float

Ratio of packets dropped by the healer compared to the total number of packets received.

This column was introduced in Microsoft Lync Server 2013.

HealerFECPacketUsedRatio

float

Ratio of used forward error correction packets compared to the total number of packets received.

This column was introduced in Microsoft Lync Server 2013.

MaxCompressedSamples

float

Maximum number of audio packets that were compressed by the healer.

This column was introduced in Microsoft Lync Server 2013.

LossCongestionPercent

float

Indicates the percentage of the time when the call was in a loss congestion state.

This column was introduced in Microsoft Lync Server 2013.

DelayCongestionPercent

float

Indicates the percentage of the call during which congestion was caused by the delayed arrival of network packets.

This column was introduced in Microsoft Lync Server 2013.

ContentionDetectedPercent

float

Indicates the percentage of the time when the call was competing for network resources.

This column was introduced in Microsoft Lync Server 2013.

BandwidthEstMin

int

Minimum amount of bandwidth estimation measured during the call.

This column was introduced in Microsoft Lync Server 2013.

BandwidthEstMax

int

Maximum amount of bandwidth estimation measured during the call.

This column was introduced in Microsoft Lync Server 2013.

BandwidthEstStdDev

int

Standard deviation of the bandwidth estimation measured during the call.

This column was introduced in Microsoft Lync Server 2013.

BandwidthEstAvge

int

Average amount of bandwidth estimation measured during the call.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayTotal

float

Total amount of one-way latency. Relative one-way latency measures the delay between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayAverage

float

Average amount of one-way latency. Relative one-way latency measures the delay between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayMax

float

Maximum amount of one-way latency. Relative one-way latency measures the delay between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayBurstOccurrences

int

Total one-way burst occurrences. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayBurstDensity

float

Total one-way burst density. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayBurstDuration

float

Total one-way burst duration. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayGapOccurrences

int

Total one-way gap occurrences. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream; gaps indicate delays between these bursts. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayGapDensity

float

Total one-way gap density. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream; gaps indicate delays between these bursts. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayGapDuration

float

Total one-way gap duration. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream; gaps indicate delays between these bursts. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

DecodeStereoPercent

float

Percentage of the call decoded as stereo.

This column was introduced in Microsoft Lync Server 2013.

AecRenderStereoPercent

float

Percentage of the call rendered as stereo by the acoustic echo canceller.

This column was introduced in Microsoft Lync Server 2013.

AudioPostFECPLR

float

Packet loss rate after forward error correction has been applied.

This column was introduced in Microsoft Lync Server 2013.

EncodeStereoPercent

float

Percentage of the call encoded as stereo.

This column was introduced in Microsoft Lync Server 2013.

AecCaptureStereoPercent

float

Percentage of the call captured as stereo by the acoustic echo canceller.

This column was introduced in Microsoft Lync Server 2013.