Symptoms

Assume that you deploy Monitoring Server Reports in a Microsoft Lync Server 2010 environment. If the Call Detail Recording (CDR) and Quality of Experience (QoE) databases are populated by more than 2,000 users, the out-of-the-box reports are delayed by 2 to 10 minutes. Additionally, Monitoring Server Reports experiences poor performance.

Resolution

To resolve this issue, download and install the following cumulative update:

Upgrade and redeploy the Monitoring Server Reports pack. For more information about how to do this, go to the "More information" section.

Note You must redeploy the monitoring pack as soon as the install-csdatabase –update command is run on the monitoring server.

Upgrade the Monitoring database. For more information about how to do this, go to the "More information" section.

More Information

Upgrade Monitoring Server Report

To upgrade the Monitoring Server Reports pack, follow these steps.

Note You can apply these steps when you deploy Monitoring Server Reports for the first time.

As a member of the DomainAdmins group, log on to any server in the domain that has the cumulative update installed.

Run the Setup.exe file in the Lync Server 2010 installation folder or media to start the Deployment Wizard.

In the Deployment Wizard, click Deploy Monitoring Server Reports.

On the Specify Monitoring Server page, specify the Monitoring server that will collect and store the CDR and QoE data.

On the Specify Monitoring Server wizard page, specify the instance of SQL Server Reporting Services that will publish the reports.

Note To publish the reports, you must disable the Federal Information Processing Standards (FIPS)-compliant algorithm policy on the Reporting Services Server. Alternatively, you can apply the workaround that is described in the following Microsoft Knowledge Base article:

911722 You may receive an error message when you access ASP.NET Web pages that have ViewState enabled after you upgrade from ASP.NET 1.1 to ASP.NET 2.0

On the Specify Credential page, specify the user credentials that will be used to access the Monitoring Server store (QoEMetrics and LcsCDR databases). For more information, go to the following MSDN website:

Important When you run the Install-CsDatabase command without the DatabasePaths parameter or the UseDefaultSqlPath parameter, as occurs in step 3, the command uses a built-in algorithm to determine the best placement for the log and data files. The algorithm works only for stand-alone SQL Server implementations. It is not intended for use on SQL Server clusters. SQL Server clusters should use either DatabasePaths to define the paths for log and data files, or UseDefaultSqlPath.

Note The articles that are listed in the "References" section contain more information about how to use the Install-CsDatabase Lync Server 2010 PowerShell command.

References

For more information about how to deploy Monitoring Server Reports, go to the following Microsoft website: