VoIP monitoring

ServicePilot voip-skype-for-business-databases

What are Skype For Business Databases ?

Skype for Business VoIP environments include built-in Microsoft SQL Server (MSSQL).

Depending on your Skype for Business 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 / Skype for Business deployment since they are a central piece to data and file placement in :
    • Application
    • Archiving
    • Monitoring
    • Central management
    • Skype for Business Core
    • Users

Skype For Business Databases monitoring

The ServicePilot Skype For Business Databases package collects Skype For Business Microsoft SQL Databases statistics.

  • This package automatically configures the ServicePilot Manager to collect statistics from Skype For Business Databases 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