AudioStream table in Lync Server 2013
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 in Lync Server 2013. |
SessionSeq |
int |
Primary |
Referenced from the MediaLine table in Lync Server 2013. |
MediaLineLabel |
tinyint |
Primary |
Referenced from the MediaLine table in Lync Server 2013. |
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. |