AudioSignal table in Lync Server 2013

 

Topic Last Modified: 2013-11-12

Each record represents audio signal metrics for one endpoint. Usually, each call has two records, one is for caller, and one is for callee.

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.
FromCaller	bit	Primary	0: Callee’s data 1: Caller’s data
SendSignalLevel	int		Represents the Post-Analog Gain Control audio signal level. The unit for this metric is dBmo. For acceptable quality, it should be at least 30 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.
RecvSignalLevel	int		See SendSignalLevel.
SendNoiseLevel	int		Represents the Post-Analog Gain Control audio noise level. The unit for this metric is dBmo. For acceptable quality, it should be less than 35 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.
RecvNoiseLevel	int		See SendNoiseLevel.
EchoReturn	int		Echo Return Loss Enhancement metric. The unit for this metric is dB. Lower values represent less echo. This metric is not reported by the A/V Conferencing Server or IP phones.
AudioSpeakerGlitchRate	int		Average glitches per five minutes for the loudspeaker rendering. For good quality, this should be less than one per five minutes. Not reported by A/V Conferencing Servers, Mediation Servers, or IP phones.
AudioMicGlitchRate	int		Average glitches per five minutes for the microphone capture. For good quality this should be less than one per five minutes. Not reported by A/V Conferencing Servers, Mediation Servers, or IP phones.
AudioTimestampDriftRateMic	decimal(9,2)		Microphone device clock drift rate, relative to CPU clock.
AudioTimestampDriftRateSpk	decimal(9,2)		Speaker device clock drift rate, relative to CPU clock.
AudioTimestampErrorMicMs	decimal(9,2)		Speaker device clock drift rate, relative to CPU clock. Average microphone capture stream time stamp error, in milliseconds, in the last 20 seconds of the call.
AudioTimestampErrorSpkMs	decimal(9,2)		Average speaker render stream time stamp error, in milliseconds, in the last 20 seconds of the call.
VsEntryCauses	smallint		Voice switch is a half-duplex mode with reduced interruption ability. Causes of voice switch entry: ENTER_VS_BADTS 0x01 ENTER_VS_ECHO 0x02 ENTER_VS_FORCEORCONVERGENCE 0x04 ENTER_VS_DNLP 0x08 The cause can be a combination of those individual causes. ENTER_VS_FORCEORCONVERGENCE can only be enabled by regkey for test purpose. The data type for this column was changed in Microsoft Lync Server 2013.
EchoEventCauses	tinyint		Causes of an echo event: ECHO_EVENT_BAD_TIMESTAMP 0x01 ECHO_EVENT_POSTAEC_ECHO 0x02 ECHO_EVENT_ANLP 0x04 ECHO_EVENT_DNLP 0x08 ECHO_EVENT_MIC_CLIPPING 0x10 ECHO_EVENT_BAD_STATE 0x20 The cause can be a combination of those individual causes.
EchoPercentMicIn	decimal(5,2)		Percentage of time when echo was detected in the microphone capture stream. Typically, values are low for headsets or handsets, and higher for speaker phones or stand-alone speakers. For devices that support on-board acoustic echo cancellation, high values indicate echo leak. For other devices, this metric should not be used to evaluate device quality.
EchoPercentSend	decimal(5,2)		Percentage of time when echo is detected in sent stream. High echo percentage in send streams an indication of echo leak.
RxAGCSignalLevel	int		Received signal level on the Mediation Server from the Gateway; this applies only to the Mediation Server. The unit of this metric is dBoV. For good quality, the acceptable range should be [-30 to -18] dBoV.
RxAGCNoiseLevel	int		Received signal level on the Mediation Server from the Gateway. This applies only to the Mediation Server. The unit of this metric is dBoV. For good quality, the acceptable range should be less than -50 dBoV.
RxAvgAGCGain	int		Automatic gain control (AGC) on the Mediation Server side.
InitialSignalLevelRMS	float		The root mean square (RMS) of the incoming signal of up to the first 30 seconds of the call.
RecvSignalLevelCh1	int		Signal level as received on channel 1. This column was introduced in Microsoft Lync Server 2013.
RecvSignalLevelCh2	int		Signal level as received on channel 2. This column was introduced in Microsoft Lync Server 2013.
RecvNoiseLevelCh1	int		Noise level as received on channel 1. This column was introduced in Microsoft Lync Server 2013.
RecvNoiseLevelCh2	int		Noise level as received on channel 2. This column was introduced in Microsoft Lync Server 2013.
SendSignalLevelCh1	int		Signal level as sent on channel 1. This column was introduced in Microsoft Lync Server 2013.
SendSignalLevelCh2	int		Signal level as sent on channel 2. This column was introduced in Microsoft Lync Server 2013.
SendNoiseLevelCh1	int		Noise level as sent on channel 1. This column was introduced in Microsoft Lync Server 2013.
SendNoiseLevelCh2	int		Noise level as sent on channel 2. This column was introduced in Microsoft Lync Server 2013.