Response group usage report takes longer time to run or cannot complete in a Lync Server 2013 environment

Applies to: Lync Server 2013


To resolve this issue, install the July 2015 cumulative update 5.0.8308.920 for Microsoft Lync Server 2013 Core Components. 

Note After you install this update, you must update the Transact-SQL query by running LyncUpdateInstaller.exe, and then run the following command in Lync Server Management Shell:
Install-CsDatabase –ConfiguredDatabases –Update –SqlServerFqdn 

Note This update includes performance improvements for the response group usage Transact-SQL query in Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2012, and Microsoft SQL Server 2014.


This issue occurs because the Transact-SQL query takes a too long time to complete, or the query times out.