Databases for Skype for Business

Prognosis includes a set of pre-packaged Database documents that are used to collect operating data from the Skype for Business environment. While the running of some of these Databases is optional, it is recommended that they be started in order to obtain a full data collection for the reporting facility.

The Databases should be run on each Monitoring Server, excepting the 'Lync-CDR-Search' 'Root Cause' and 'Related Voice Streams' databases which are run on the Management Server.

The pre-packaged databases include

Monitoring Server

Database nameTypeWrapping Interval (1)Maximum Size (1)Start
Lync-CDRCollection15 Days20 GB MBManual
Lync-ReportsCollection14 Days5 GBManual
Lync-Reports 1 Hourly
Summary14 Days1 GBAutomatic (2)
Lync-Reports - 6 HourlySummary14 Days1 GBAutomatic (2)
Lync-Reports DailySummary62 Days1 GBAutomatic (2)
Lync-VideoQualityCollection15 Days8 GBManual
Server StatisticsCollection2 Days10 GBManual
Server Statistics 1 HourlySummary14 Days1 GBAutomatic (2)
Server Statistics 6 HourlySummary14 Days1 GBAutomatic (2)
Server Statistics DailySummary62 Days1 GBAutomatic (2)
Lync-TroubleshootingCollection15 Days1 GBManual
(1) These values may be incorrect, please validate with the actual information on each Database property page.

(2) The Database Summaries will start automatically after the associated Database Collection has started.

Starting Databases

Web Application

When initially configuring a new device using the Web Application, these databases will be started automatically after the 'Start standard databases and thresholds' option is selected.

The three associated 'Lync Reports-<time_period>' Databases will start automatically once the 'Lync Reports' Database has started and the three associated 'Server Statistics-<time_period>' Databases will start automatically once the 'Server Statistics' Database has started.

Windows Client

When initially configuring a new device using the Windows Client, these databases will need to be started manually. To do this, go to the folder path, as shown below, in the Document Navigator and then drag the Database or Command document down onto the required Monitoring Server(s) in the Node Navigator.

a)

Folder path: Knowledge > IP Telephony Manager > Microsoft > Lync > Databases

  • Lync-CDR

  • Lync-Troubleshooting

  • Lync-VideoQuality

Note: Do not start the Lync-Reports Database from here, use the Command as shown in the next point, otherwise the associated 'Lync Reports <time-period>' Databases will not be started.

b)

Folder path: Knowledge > IP Telephony Manager > Microsoft > Lync > Commands

  • Start Lync - Reports DB (Command document)

This Command will start the 'Lync-Reports' Database and then automatically start the three associated 'Lync Reports <time-period>' Databases.

c)

Folder path: Knowledge > Common > WMI > Commands

  • Start Server Statistics (Command document)

This command will start the 'Server Statistics' Database and then automatically start the three associated 'Server Statistics-<time_period>' Databases.

d)

Folder path: Knowledge > Common > Voice Streams > Databases

  • Related Voice Streams

Management Server

Database nameTypeWrapping Interval (1)Maximum Size (1)Start
Lync-CDR-SearchCollection15 Days8 GBManual
Root Cause
Collection14 Days100 MBManual

Related Voice Streams

Used by the Prognosis Voice Quality 360 feature. For details see Voice Quality 360 for Skype for Business

Collection15 Days30 GBManual
(1) These values may be incorrect, please validate with the actual information on each Database property page.

(2) The Database Summaries will start automatically after the associated Database Collection has started.

Starting Databases

Web Application

These databases will need to be started manually on the Management Server. To do this open the Web Application - Administration tool and in the navigation panel click on the required Management Server name. Then go to the Databases section in the main panel, this section will show if the Database is currently running or not. If it is not running select the Start New button which will open a Database list. From the list scroll down to the Database name, click the adjacent radio button and then go to the end of the list and click the Start button. Wait until a prompt is displayed saying 'Database started successfully' and then click the OK button. Repeat this for each database.

Windows Client

These databases will need to be started manually on the Management Server. To do this, go to the folder path, as shown below, in the Document Navigator and then drag the Database document down onto the required Management Server in the Nodes Navigator.

a)

 Folder path: Knowledge > IP Telephony Manager >Microsoft > Lync > Databases

  • Lync-CDR-Search

b)

Folder path: Knowledge > Common > Root Cause

  • Root Cause

Provide feedback on this article