Share via


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:

  • 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.