Cisco Cisco TelePresence Management Suite (TMS) Version 15 Installation Guide
Regular maintenance tasks
As a best practice, set up regular maintenance tasks for backups and index maintenance. Beware that
database maintenance impacts Cisco TMS performance. Perform these tasks during your organization's
scheduled maintenance windows.
database maintenance impacts Cisco TMS performance. Perform these tasks during your organization's
scheduled maintenance windows.
Backup
Set up tasks to back up the server in accordance with your organization's recovery policies, and once per
week as a minimum:
week as a minimum:
n
n
(SQL Server 2008 R2)
n
(SQL Server 2008)
Index maintenance
Perform maintenance on the database indexes at regular intervals to avoid excessive fragmentation. We
suggest rebuilding the indexes monthly, or when fragmentation goes past 30%.
suggest rebuilding the indexes monthly, or when fragmentation goes past 30%.
n
n
(SQL Server 2008 R2)
n
(SQL Server 2008)
SQL Server Maintenance Plan
If using the full version of SQL Server (not Express), built-in maintenance plan features and a wizard are
available for tasks like the above. For guidance, see the following Microsoft articles:
available for tasks like the above. For guidance, see the following Microsoft articles:
n
(SQL Server 2012)
n
(SQL Server 2008 R2)
n
(SQL Server 2008)
Database size management
We strongly recommend against having a regular maintenance task for shrinking the database. Over time,
the database size will normally stabilize, and can be specified as a fixed size with an added 30% buffer.
the database size will normally stabilize, and can be specified as a fixed size with an added 30% buffer.
On some occasions, the database size may grow significantly during an upgrade. In these cases, we
recommend a one-time operation to shrink the database.
recommend a one-time operation to shrink the database.
Security
This section presents recommended and suggested measures to make your Cisco TMS deployment more
secure.
secure.
Web and API communication
By default, the Cisco TMS installer will set up HTTPS for web communication, offering to create a self-
signed certificate if the administrator does not provide one. For improved security, we strongly recommend
using valid certificates signed by a certificate authority.
signed certificate if the administrator does not provide one. For improved security, we strongly recommend
using valid certificates signed by a certificate authority.
Cisco TelePresence Management Suite Installation and Upgrade Guide (14.5)
Page 20 of 56
Deployment best practices