AppSharingStream table in Lync Server 2013
Topic Last Modified: 2014-02-21
The AppSharingStream table contains Quality of Experience metrics for the network streams used for application sharing. This table was introduced in Microsoft Lync Server 2013.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
ConferenceDateTime |
dateTime |
Primary, Foreign |
Date and time that the session started. |
SessionSeq |
int |
Primary, Foreign |
Sequential identifier used to distinguish between sessions that started on the same date and at the same time. |
MediaLineLabel |
tinyint |
Primary, Foreign |
Represents the type of video line used in the call. Allowed values are:
|
StreamID |
int |
Primary |
Unique identifier of the application sharing stream. |
JitterInterArrival |
int |
Average jitter detected between RTP packet arrivals. (Jitter is a measure of the "shakiness" of a call.) High jitter values are typically caused by congestion or an overloaded media server, and result in distorted or lost audio. |
|
JitterInterArrivalMax |
int |
Maximum jitter detected between RTP packet arrivals. (Jitter is a measure of the "shakiness" of a call.) High jitter values are typically caused by congestion or an overloaded media server, and result in distorted or lost audio. |
|
RoundTrip |
int |
Average amount of (in milliseconds) required for a Real-Time Transport Protocol packet to travel to another endpoint and then back. Round-trip times of 200 milliseconds or less are considered of acceptable quality. High round-trip values can be caused by international call routing; a routing misconfiguration; or an overloaded media server. High round-trip times result in difficulties with two-way, real-time audio conversations. |
|
RoundTripMax |
int |
Maximum amount of (in milliseconds) required for a Real-Time Transport Protocol packet to travel to another endpoint and then back. Round-trip times of 200 milliseconds or less are considered of acceptable quality. High round-trip values can be caused by international call routing; a routing misconfiguration; or an overloaded media server. High round-trip times result in difficulties with two-way, real-time audio conversations. |
|
PacketLossRate |
float |
Average rate of Real-Time Transport Protocol (RTP) packet loss. (Packet loss occurs when RTP packets, a protocol used for transmitting audio and video across the Internet, failed to reach their destination.) High loss rates are generally caused by congestion; lack of bandwidth; wireless congestion or interference; or an overloaded media server. Packet loss typically results in distorted or lost audio. |
|
PacketLossRateMax |
float |
Maximum rate of Real-Time Transport Protocol (RTP) packet loss. (Packet loss occurs when RTP packets, a protocol used for transmitting audio and video across the Internet, failed to reach their destination.) High loss rates are generally caused by congestion; lack of bandwidth; wireless congestion or interference; or an overloaded media server. Packet loss typically results in distorted or lost audio. |
|
PacketUtilization |
int |
Number of packets sent. |
|
BandwidthEst |
int |
Estimated one-way bandwidth available at the end of the session. Reported in bits per second. |
|
AppSharingPayloadDescription |
int |
Description of the application sharing payload. |
|
RelativeOneWayTotal |
float |
Total amount of one-way latency. Relative one-way latency measures the delay between the client and the server. |
|
RelativeOneWayAverage |
float |
Average amount of one-way latency. Relative one-way latency measures the delay between the client and the server. |
|
RelativeOneWayMax |
float |
Maximum amount of one-way latency. Relative one-way latency measures the delay between the client and the server. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
ApplicationSharingType |
varChar(256) |
Application role (Sharer or Viewer) and content type. |
|
RDPTileProcessingLatencyTotal |
float |
Total processing time for remote desktop protocol (RDP) tiles. A higher total equates to a longer delay in the viewing experience. |
|
RDPTileProcessingLatencyAverage |
float |
Average processing time for remote desktop protocol (RDP) tiles. A higher total equates to a longer delay in the viewing experience. |
|
RDPTileProcessingLatencyMax |
float |
Maximum processing time for remote desktop protocol (RDP) tiles. A higher total equates to a longer delay in the viewing experience. |
|
RDPTileProcessingLatencyBurstOccurrences |
int |
Burst occurrences in the processing time for remote desktop protocol (RDP) tiles. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream. |
|
RDPTileProcessingLatencyBurstDensity |
float |
Burst density in the processing time for remote desktop protocol (RDP) tiles. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream. |
|
RDPTileProcessingLatencyBurstDuration |
float |
Burst duration in the processing time for remote desktop protocol (RDP) tiles. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream. |
|
RDPTileProcessingLatencyGapOccurrences |
int |
Gap occurrences in the processing time for remote desktop protocol (RDP) tiles. |
|
RDPTileProcessingLatencyGapDensity |
float |
Gap density in the processing time for remote desktop protocol (RDP) tiles. Low gap density equates to a better viewing experience. |
|
RDPTileProcessingLatencyGapDuration |
float |
Gap duration in the processing time for remote desktop protocol (RDP) tiles. Short gap durations equate to a better viewing experience. |
|
CaptureTileRateTotal |
float |
Total rate of captured tiles (in tiles per second). |
|
CaptureTileRateAverage |
float |
Average rate of captured tiles (in tiles per second). |
|
CaptureTileRateMax |
float |
Maximum rate of captured tiles (in tiles per second). |
|
CaptureTileRateBurstOccurrences |
in t |
Burst occurrences in the rate of captured tiles (in tiles per second). |
|
CaptureTileRateBurstDensity |
float |
Burst density in the rate of captured tiles (in tiles per second). |
|
CaptureTileRateBurstDuration |
float |
Burst duration in the rate of captured tiles (in tiles per second). |
|
CaptureTileRateGapOccurrences |
int |
Gap occurrences in the rate of captured tiles (in tiles per second). |
|
CaptureTileRateGapDensity |
float |
Gap density in the rate of captured tiles (in tiles per second). |
|
CaptureTileRateGapDuration |
float |
Gap duration in the rate of captured tiles (in tiles per second). |
|
SpoiledTilePercentTotal |
float |
Total percentage of the content that did not reach the viewer but was instead discarded and overwritten by fresh content. |
|
SpoiledTilePercentAverage |
float |
Average percentage of the content that did not reach the viewer but was instead discarded and overwritten by fresh content. |
|
SpoiledTilePercentMax |
float |
Maximum percentage of the content that did not reach the viewer but was instead discarded and overwritten by fresh content. |
|
SpoiledTilePercentBurstOccurrences |
int |
Burst occurrences for the content that did not reach the viewer but was instead discarded and overwritten by fresh content. |
|
SpoiledTilePercentBurstDensity |
float |
Burst density for the content that did not reach the viewer but was instead discarded and overwritten by fresh content. |
|
SpoiledTilePercentBurstDuration |
float |
Burst duration for the content that did not reach the viewer but was instead discarded and overwritten by fresh content. |
|
SpoiledTilePercentGapOccurrences |
int |
Gap occurrences for the content that did not reach the viewer but was instead discarded and overwritten by fresh content. |
|
SpoiledTilePercentGapDensity |
float |
Gap density for the content that did not reach the viewer but was instead discarded and overwritten by fresh content. |
|
SpoiledTilePercentGapDuration |
float |
Gap duration for the content that did not reach the viewer but was instead discarded and overwritten by fresh content. |
|
ScrapingFrameRateTotal |
float |
Total number of frames scraped from the graphics source. |
|
ScrapingFrameRateAverage |
float |
Average number of frames scraped from the graphics source. |
|
ScrapingFrameRateMax |
float |
Maximum number of frames scraped from the graphics source. |
|
ScrapingFrameRateBurstOccurrences |
int |
Burst occurrences in the frames scraped from the graphics source. |
|
ScrapingFrameRateBurstDensity |
float |
Burst density in the frames scraped from the graphics source. |
|
ScrapingFrameRateBurstDuration |
float |
Burst duration in the frames scraped from the graphics source. |
|
ScrapingFrameRateGapOccurrences |
int |
Gap occurrences in the frames scraped from the graphics source. |
|
ScrapingFrameRateGapDensity |
float |
Gap density in the frames scraped from the graphics source. |
|
ScrapingFrameRateGapDuration |
float |
Gap duration in the frames scraped from the graphics source. |
|
IncomingTileRateTotal |
float |
Total incoming frame rate as received by the viewer. |
|
IncomingTileRateAverage |
float |
Average incoming frame rate as received by the viewer. |
|
IncomingTileRateMax |
float |
Maximum incoming tile rate as received by the viewer. |
|
IncomingTileRateBurstOccurrences |
int |
Burst occurrences in the incoming tile rate as received by the viewer. |
|
IncomingTileRateBurstDensity |
float |
Burst density in the incoming tile rate as received by the viewer. |
|
IncomingTileRateBurstDuration |
float |
Burst duration in the incoming tile rate as received by the viewer. |
|
IncomingTileRateGapOccurrences |
int |
Gap occurrences in the incoming tile rate as received by the viewer. |
|
IncomingTileRateGapDensity |
float |
Gap density in the incoming tile rate as received by the viewer. |
|
IncomingTileRateGapDuration |
float |
Gap duration in the incoming tile rate as received by the viewer. |
|
IncomingFrameRateTotal |
float |
Total incoming frame rate as received by the viewer. |
|
IncomingFrameRateAverage |
float |
Average incoming frame rate as received by the viewer. |
|
IncomingFrameRateMax |
float |
Maximum incoming frame rate as received by the viewer. |
|
IncomingFrameRateBurstOccurrences |
int |
Burst occurrences in the incoming frame rate as received by the viewer. |
|
IncomingFrameRateBurstDensity |
float |
Burst density in the incoming frame rate as received by the viewer. |
|
IncomingFrameRateBurstDuration |
float |
Burst duration in the incoming frame rate as received by the viewer. |
|
IncomingFrameRateGapOccurrences |
int |
Gap occurrences in the incoming frame rate as received by the viewer. |
|
IncomingFrameRateGapDensity |
float |
Gap density in the incoming frame rate as received by the viewer. |
|
IncomingFrameRateDuration |
float |
Gap duration in the incoming frame rate as received by the viewer. |
|
OutgoingTileRateTotal |
float |
Total outgoing tile rate for the sender. |
|
OutgoingTileRateAverage |
float |
Average outgoing tile rate for the sender. |
|
OutgoingTileRateMax |
float |
Maximum outgoing tile rate for the sender. |
|
OutgoingTileRateBurstOccurrences |
int |
Burst occurrences in the outgoing tile rate for the sender. |
|
OutgoingTileRateBurstDensity |
float |
Burst density in the outgoing tile rate for the sender. |
|
OutgoingTileRateBurstDuration |
float |
Burst duration in the outgoing tile rate for the sender. |
|
OutgoingTileRateGapOccurrences |
int |
Gap occurrences in the outgoing tile rate for the sender. |
|
OutgoingTileRateGapDensity |
float |
Gap density in the outgoing tile rate for the sender. |
|
OutgoingTileRateGapDuration |
float |
Gap duration in the outgoing tile rate for the sender. |
|
OutgoingFrameRateTotal |
float |
Total outgoing frame rate for the sender. |
|
OutgoingFrameRateAverage |
float |
average outgoing frame rate for the sender. |
|
OutgoingFrameRateMax |
float |
Maximum outgoing frame rate for the sender. |
|
OutgoingFrameRateBurstOccurrences |
int |
Burst occurrences in the outgoing frame rate for the sender. |
|
OutgoingFrameRateBurstDensity |
float |
Burst density in the outgoing frame rate for the sender. |
|
OutgoingFrameRateBurstDuration |
float |
Burst duration in the outgoing frame rate for the sender. |
|
OutgoingFrameRateGapOccurrences |
int |
Gap occurrences in the outgoing frame rate for the sender. |
|
OutgoingFrameRateGapDensity |
float |
Gap density in the outgoing frame rate for the sender. |
|
OutgoingFrameRateGapDuration |
float |
Gap duration in the outgoing frame rate for the sender. |
|
AverageRectangleHeight |
int |
Average video resolution height, in pixels. |
|
AverageRectangleWidth |
int |
Average video resolution width, in pixels. |
|
Inbound |
bit |
Average frame rate (in frames per second) for inbound transmissions. |
|
Outbound |
bit |
Average frame rate (in frames per second) for outbound transmissions. |
|
SenderIsCallerPAI |
bit |
1 means the stream direction is from the caller to callee. 0 means the stream direction is from the callee to the caller. |