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
Represents the type of video line used in the call. Allowed values are:
0 - Audio
1 - Video
2 - Panoramic video
3 -Application/Desktop Sharing
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.