VoIP monitoring
with the MICROSOFT-LYNC-2013-BACK-END-SQL package

ServicePilot voip-microsoft-lync-2013-back-end-sql

What is Microsoft Lync 2013 Back End SQL ?

Microsoft Lync 2013 VoIP environments include built-in Microsoft SQL Server (MSSQL).

Depending on your Microsoft Lync 2013 pool design, there are couple of places that MSSQL databases are usually installed.

In the case of an Enterprise Edition Front end Pool, Master databases (called RTC) are installed on a dedicated SQL backend server and a read-only copy of the master is installed locally on each front end server (called RTCLOCAL). Some of the databases are hosted primarily on the backend like Monitoring, Archiving, Persistent chat.

A standard edition pool deployment the master XDS and the replica (copy) will be both hosted in the same server using SQL Express server.

Those SQL databases are vital to a Lync deployment since they are a central piece to data and file placement in:

  • Application
  • Archiving
  • Monitoring
  • Central management
  • Microsoft Lync 2013 Core
  • Users

Microsoft Lync 2013 Back End SQL monitoring

The ServicePilot Microsoft Lync 2013 Back End SQL package collects Microsoft Lync 2013 Microsoft SQL Databases statistics.

This package automatically configures the ServicePilot Agent to collect statistics from Microsoft Lync 2013 Back End SQL using WMI.

It discovers and provides statistics for each MSSQL instance, and details metrics per instance database.

The statistics gathered in this way include:

  • Logins and logouts
  • MARS Deadlocks
  • Processes Blocked
  • Transactions
  • Data Files Size
  • Log Cache Hits
  • and more