Voip Monitoring

microsoft lync 2013 back end sql VoIP monitoring

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

How to install a microsoft-lync-2013-back-end-sql resource?

  1. Use your ServicePilot OnPremise installation or a SaaS account.
  2. Add a new microsoft-lync-2013-back-end-sql resource via the web interface (/prmviews or /prmresources) or via API (/prmpackages page), the default ServicePilot agent or another agent will be provisioned automatically.

Details of the microsoft-lync-2013-back-end-sql package are located in the /prmpackages page of the software.


ServicePilot enables you to deliver IT services faster and more securely with automated discovery and advanced monitoring features.

By correlating the technology MICROSOFT LYNC 2013 BACK END SQL with APM and infrastructure monitoring, ServicePilot is able to provide a more comprehensive view of an organization's IT environment.

This allows IT teams to quickly identify and diagnose issues that may be impacting application performance, and take corrective action before end-users are affected.

Start with a free trial of our SaaS solution. Explore our plans or contact us to find what works best for you.

Learn more

Free installation in
a few clicks

SaaS Plateform

Flexible deployment according to your needs (SaaS, hybrid, on-premise) to speed up supervision implementation.
  • No on-premise software setup, servicing and configuration complexity
  • Instant setup, complete and pre-configured to ensure robust monitoring

OnPremise Plateform

Flexible deployment according to your needs (SaaS, hybrid, on-premise) to speed up supervision implementation.
  • Contracts and commitments over time ( > 1 year)
  • Performance, Data Storage and Infrastructure Management
  • 2 additional solutions: VoIP and Mainframe monitoring