AppSharingStream table
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 |
See MediaLine Table. |
| 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. |