Cisco Systems Conference Phone manual Msde Database Size, Related Topics

Page 20

Chapter 2 Installing Cisco Unified MeetingPlace Web Conferencing Release 5.3

About the Cisco Unified MeetingPlace Web Conferencing Release 5.3 Installation

All new servers being deployed must be either Cisco MCS or, for MeetingPlace customers with a legacy system, Cisco MCS-equivalent servers.

Cisco Unified MeetingPlace Web Conferencing comes with a distributable version of SQL Server called MSDE 2000. Although MSDE 2000 and SQL Server 2000 are based on the same technology, MSDE 2000 does not scale as well as SQL Server 2000. Because of this by-design limitation, Cisco Unified MeetingPlace Web Conferencing customers running MSDE 2000 can encounter performance and scalability-related problems when their usage of Cisco Unified MeetingPlace Web Conferencing grows.

The following sections provide information about how to anticipate and diagnose performance and scalability limitations related to MSDE:

•MSDE Database Size, page 2-2

•MSDE Database Scalability, page 2-2

MSDE Database Size

MSDE limits the database size to 2 GB. If either the MPWEB or the MPWEB-Slave database reaches 2 GB, the Cisco Unified MeetingPlace Web Conferencing application can fail. Therefore, you must monitor the growth of the MPWEB databases and take one of the following actions before either database reaches 2 GB:

•Set a more aggressive value for the Purge meetings held before (Days) parameter. For more information, see the “About the MeetingNotes Purge Parameter” section in Chapter 3 of the Configuration Guide for Cisco Unified MeetingPlace Web Conferencing Release 5.3.

•Upgrade to a full version of SQL Server with a per processor license, as this does not have a database size limitation.

MSDE Database Scalability

MSDE implements a concurrent workload throttle mechanism to limit scalability under heavy load. Currently, this mechanism activates when more than eight SQL queries execute concurrently. However, there is no direct mapping between the number of active web-conferencing users and the exceeding of this limit.

Rather, the exceeding of this limit depends on the following:

•Number of active users

•Features that are used at any given time and how these features interact with the database

•Current size of the database

•Power of the server (CPU, disks, and so on)

Although Microsoft does not give information about the specific algorithm that is used to implement this concurrent workload throttle mechanism, our tests show that the slowdown is based on the number of SQL queries that exceed the limit of eight queries. For example, if 10 concurrent queries execute, the slowdown is minimal. If 20 concurrent queries execute, the slowdown is more noticeable. If 40 or more concurrent queries execute, the slowdown can become so significant that users find Cisco

Unified MeetingPlace Web Conferencing as unresponsive or non-functional.

Related Topics

•See the “How to Assess Performance Degradation Due to the Database Scalability Limitation of MSDE” section in the Configuration Guide for Cisco Unified MeetingPlace Web Conferencing Release 5.3.

Installation and Upgrade Guide for Cisco Unified MeetingPlace Web Conferencing Release 5.3

2-2

OL-10029-01

 

 

Page 19 Page 21
Image 20
Page 19 Page 21
Contents Corporate Headquarters Copyright 2004-2006 Cisco Systems, Inc. All rights reserved N T E N T S About the SMA-2S Configuration with SSL and Segmented DNS Releases What to Do First Preface Naming Conventions Term DefinitionAdditional References Preface Additional References About Cisco Unified MeetingPlace Configuration Restrictions Terms for Single Sign On Software IntegrationTerms of Support for Single Sign On Software Integration New Features and Enhancements in Release Feature DescriptionFeature Description New Features and Enhancements in Release New Features and Enhancements in Release Feature Description About SQL Server Integration Msde Database Size Related TopicsAbout SQL Server Installation Options If the following conditions are metAbout Sun Java Runtime Environment Creating a Least Privileged SQL Account Installing Cisco Unified MeetingPlace Audio Server ReleaseInstalling SQL Server on a Remote Server Assigning Installation and Ongoing Rights ProcedureTroubleshooting Tips RestrictionsInternal Full Access Installing the Operating System on the Cisco MCS Server Before You Begin Restriction Procedure Testing the Web Server Over an Http Connection Testing the Web Server Over an Https Connection Testing the Meeting Console ConnectionAbout Segmented Meeting Access About the SMA-1S Configuration LAN/WAN DMZAbout the SMA-2S Configuration About the SMA-2S Configuration with SSL and Segmented DNS ExampleGathering Basic Information About Your Web Server What to Do Next Information, see the About SQL Server Integration section on Restrictions Before You Begin OL-10029-01 A P T E R Cisco Unified MeetingPlace Web Conferencing Clusters One Cluster Configuration 121506 Then InternalDefault Behavior of Load Balancing in Video-Enabled Systems Suggestions for a Robust Cisco Unified MeetingPlace SystemVideo Meetings in Segmented Meeting Access Deployments SQL Server ConsiderationsInstall the first internal web server End-User ConsiderationsPreparing the Internal Cluster Preparing the External Cluster Creating a Common Storage Location Installing the First Internal Web Server Configuring Services for the First Internal Web ServerProcedure Installing Additional Internal Web Servers Registry Key ActionInstalling the First External Web Server Copying Guids From the Internal to the External Web ServerConfiguring Services for the First External Web Server Procedure Installing Additional External Web Servers Configuring Redirection of External Meetings Configuring Ad-Hoc Video Meetings Viewing the Amount of Web-Conferencing Load on a Server Disabling Load BalancingOL-10029-01 A P T E R User Authentication Methods in Release 5.3235 and Later Load Balancing in Release 5.3333 and LaterRight-clickMPWEB and choose All Tasks Backup Database Backing Up the Mpweb Database and MPWEB-Slave DatabaseBacking Up Cisco Unified MeetingPlace Registry Information Open ExplorerThis section contains the following procedures Upgrading a Standalone Web Server Restrictions Upgrading Web Servers Sharing the Same Database Uninstalling Cisco Unified MeetingPlace Web Conferencing Click Change/RemoveReboot your server Removing SQL Server or MsdeWhat to Do First Obtaining Additional Assistance Checking the Cisco MCS Operating System ReleaseLocating the Software Download Page on Cisco.com Resolving Http Connection Problems Resolving Https Connection ProblemsOL-10029-01 D E IN-2 IN-3 IN-4
Top Page Image Contents