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 Agent 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
How to install a skype-for-business-databases resource?
- Use your ServicePilot OnPremise installation or a SaaS account.
- Add a new skype-for-business-databases resource via the web interface (
/prmviewsor/prmresources) or via API (/prmpackagespage), the default ServicePilot agent or another agent will be provisioned automatically.
Details of the skype-for-business-databases package are located in the
/prmpackagespage of the software.
Benefits
ServicePilot enables you to deliver IT services faster and more securely with automated discovery and advanced monitoring features.
By correlating the technology SKYPE DATABASES 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.
