Looking at VbSS video streams in QoE

In Skype for Business 2016 we introduced Video based Screen Sharing (VbSS) for peer-to-peer calls. MVP Jeff Schertz has a good post on the technical details here. As implied by the name, the screen sharing flows via video streams, but how is it possible to distinguish these streams from "normal" video streams, when analyzing quality…


MediaLineLabel in Lync 2013 QoE

The MediaLine table in the Lync 2013 and Skype for Business 2015 QoE database contains a column called MediaLineLabel. The label specifies the media type related to the MediaLine. In Lync 2010 you have been used to seeing the values 0, 1 and 2 in the column. However in Lync 2013 you might find the…


Call Quality Methodology (CQM)

During the last 6 months my colleagues Andrew, Brandon, Kent and I have been busy documenting the Call Quality Methodology or CQM as we call it. CQM is a holistic way to systematically define and assert call quality. CQM divides a Lync implementation into ten discrete areas that impact quality, defining targets and a remediation…


What is the basis for classifying a call as poor in Lync 2013 QoE?

In Lync 2013 we changed how we classify poor calls in QoE. The flag is called ClassifiedPoorCall and it is now available in the MediaLine table. It is moved here, because we now support classifying poor calls for audio, video and application sharing. We use the same classification in Skype for Business 2015. The conditions…


How to determine network connection type in QoE queries?

In many scenarios you are interested in knowing how a given caller or callee was connected to the network, i.e. was it a wired or wireless connection. The information is contained in the columns CallerNetworkConnectionType and CalleeNetworkConnectionType in the MediaLine table. It is then easy to use those columns in your SQL queries. However you…


How many sessions and streams do we see in QoE for a conference?

In QoE we store information about sessions and different type of media streams, but how many of these do we store for a conference scenario?   Let me answer that question by using the following scenario: July 11, 2013 tu14@contoso.dk drags tu26@contoso.dk and tu29@contoso.dk into a conference and they both accepts it tu14 adds audio…


Queries from our TechEd 2013 session

Sasa and I presented this session at TechEd 2013 in Madrid. In the deck we show the results of running 3 custom SQL queries against the QoE data. The query from slide 44 (Individual Poor Streams Wired to MS and AVMCU per Subnet v13.txt) and the query from slide 49 (Individual Poor Streams Wireless to…


Working with device names in QoE data

When you start working with device information in QoE you might find that there is an issue around the naming of devices. The different Lync client reports the name of the device used for capture and rendering in the QoE report sent to the Monitoring Server. However the name is based on the device name in…


Diagnosing network health issues using QoE data

In this I discussed how to view network health trends using QoE data. In this post I’ll describe some queries you can use to help you diagnose where you might have network health issues in your Lync deployment. The first query is the Streams Statistics query. The query will tell you the maximum, standard deviation…