Cisco Unified MeetingPlace, Release 7.0 -- Updating the Indices on the SQL Database

From DocWiki

Jump to: navigation, search

Main page: Cisco Unified MeetingPlace, Release 7.0

Up one level: Configuration

The SQL database needs regular maintenance. If the SQL database is running slowly, or if the SQL database is running on a remote SQL server, then you should run this procedure on a nightly or weekly basis.

  1. Launch SQL Enterprise manager.
  2. Select the Cisco Unified MeetingPlace Web Conferencing database, which is named something similar to MPWEB_<GUID_ID>_<Location>.
    <Location> can be either 1 or 2, depending on whether this is an internal or an external Web Server.
  3. Select Tools > Wizards from the menu options at the top of the window.
  4. Expand on the Management option.
  5. Select Database Maintenance Plan Wizard.
  6. Click Next on the Welcome to the Database Maintenance Plan Wizard page.
  7. Select the database on the Select Database page.
  8. Click Next.
  9. Check Reorganize data and index pages on the Update Data Optimization Information page.
  10. Click Next.
  11. (Optional) Change the schedule on which this maintenance procedure runs.
  12. Click Next on the Database Integrity Check page.
  13. Uncheck Backup the database on the Specify the database backup plan page.
  14. Click Next.
  15. Click Next on the following pages:
    • Specify backup disk directory page
    • Specify the transaction log backup plan page
    • Reports to generate page
    • Maintenance Pan History page
  16. Click Finish on the Completing the maintenance plan wizard page.

Rating: 0.0/5 (0 votes cast)

Personal tools