Cisco Cisco TelePresence Management Suite (TMS) Version 15 Maintenance Manual
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
The TMS Server Disk Space section displays the free disk space for each partition on the web server.
Note that if using an account other than sa to connect to the tmsng database, that account must have the 'sysadmin'
server role.
server role.
Viewing and Managing Database Files and Sizes
The Database Files and Size Info section provides an overview of database names, servers, and path information
about the databases, as well as the current size and maximum size of each database, and what it stores.
about the databases, as well as the current size and maximum size of each database, and what it stores.
Database management must be handled through an external tool such as Microsoft SQL Server Management Studio
Express.
Express.
For guidance on setting up a database maintenance plan, see Cisco TMS Installation and Upgrade Guide.
Purging Old Data and Logs
The Purge Old Data in Database Tables Plan section displays information about the database tables used for logs,
and caching information in Cisco TMS.
and caching information in Cisco TMS.
The Purge Log Plan section displays information about log files on the web server. For descriptions of all Cisco TMS
debug logs, see
debug logs, see
The overviews show how many entries each log file or database table currently has and how many days the entries
will be kept before they will be purged automatically.
will be kept before they will be purged automatically.
To modify the purge settings for any entry:
1.
Click on the Edit link for the desired entry.
2.
Check Enabled to initiate automatic cleanup. If left unchecked, the log will never be purged.
3.
Set the Number of Days to Keep Data before the data is purged.
4.
Click Update to save the setting.
Purge Old Data in Database Tables Plan
Database Table
Description
Endpoint/MCU Call
Log
Log
Call detail records for conferences involving endpoints/MCUs, as displayed in Reporting >
Call Detail Record > All Endpoints and MCUs.
Call Detail Record > All Endpoints and MCUs.
Gateway/Gatekeeper
Call Log
Call Log
Call detail records for conferences involving gateways/gatekeepers, as displayed in
Reporting > Call Detail Record > Gateway, Gatekeeper and VCS.
Reporting > Call Detail Record > Gateway, Gatekeeper and VCS.
Feedback Log
Events like scheduling, errors, and encryption status from systems in Cisco TMS.
The Number of Days to Keep Data field for this entry affects the Logs tab for each
system in Navigator.
system in Navigator.
For a company with several hundred endpoints, the size of this log file can become
substantial, and we recommend that you regularly purge old data.
substantial, and we recommend that you regularly purge old data.
Table 174 Database tables affected
272
Cisco TelePresence Management Suite Administrator Guide
Administrative Tools