Cisco Cisco IPCC Web Option Maintenance Manual

Page of 92
Figure 16: Configure Window
Step 2
Use this window to modify the following SQL Server parameters:
User Connections. Indicate the maximum number of users that can connect to SQL Server
at one time.
Locks. Indicate the maximum number of available locks.
Open Objects. Indicate the maximum number of available open objects.
Note: User Connections, Locks, and Open Objects are "dynamically allocated" by SQL
Server. Unified ICM does not allow you to change these options, so they are grayed out.
Open Databases. Indicate the maximum number of available open databases.
Note: Open Databases is not available in SQL 7.0 or SQL 2000.
Memory. Indicates the amount of memory (in megabytes) allocated to SQL Server processing.
Note: Memory can be configured to be a specific value instead of the SQL Server default of
"Dynamic." Specifying a value of 0 can set the Memory setting to "Dynamic."
Recovery Interval. This setting controls checkpoint frequency.
Max Async ID. Indicates the maximum number of outstanding asynchronous disk input/output
(I/O) requests that the entire server can issue against a file.
Note: Max Async ID is not available in SQL 2000.
Step 3
When you are finished configuring the server, select OK to complete the operation or select
Cancel to end the operation without making any changes.
Administration Guide for Cisco Unified ICM/Contact Center Enterprise & Hosted Release 8.x
57
Chapter 4: Database Administration
Database Administration Tool