Document ID: 23340
Contents
Introduction
Before You Begin
Conventions
Prerequisites
Components Used
Change SQL Server Configuration Settings
Enterprise Manager
ICRDBA/ICMDBA
Related Information
Introduction
This document outlines four Microsoft SQL Server 6.5 configuration parameters that must be changed from the default values in order to achieve optimal performance with Cisco Intelligent Contact Management (ICM).
Before You Begin
Conventions
For more information on document conventions, see the Cisco Technical Tips Conventions.
Prerequisites
Readers of this document should be knowledgeable of the following:
-
Ability to execute Microsoft SQL Server Enterprise Manager and alter SQL Server configuration settings
-
Familiarity with the Cisco ICM ICRDBA or ICMDBA utilities
-
Basic knowledge of the Microsoft Windows NT
Components Used
The information in this document is based on the software and hardware versions below.
-
Microsoft Windows NT
-
Microsoft SQL Server version 6.5
-
Cisco ICM 4.6.2 and earlier
The information presented in this document was created from devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If you are working in a live network, ensure that you understand the potential impact of any command before using it.
Change SQL Server Configuration Settings
On Cisco ICM servers, housing an ICM database and running Microsoft SQL Server version 6.5, there are seven SQL Server configuration parameters that need to be changed from their default values in order to achieve optimal performance on the system. Refer to the following table for these values, the optimal settings and the default settings.
|
Parameter |
Optimal Setting |
Default Setting |
|---|---|---|
|
Locks |
50000 |
5000 |
|
Max Async I/O |
255 |
16 |
|
Memory ** |
50% of RAM |
8192 (Equates to 16M of RAM) ** |
|
Open Databases |
50 |
20 |
|
Open Objects |
5000 |
50 |
|
Recovery Interval |
1 |
10 |
|
User Connections |
168 |
8 |
Note: ** In Microsoft SQL Server version 6.5, the memory setting is a 2k value, so the setting should be set to exactly half of the intended value. For example, if there is 1G of RAM installed, the recommended memory setting for ICM is a value equivalent to 500M. In Microsoft SQL Server version 6.5, the equivalent setting is 250000, because 250000 x 2k is equal to 500M.
Enterprise Manager
To check and change these values on any Cisco ICM Logger, Distributor AW, or HDS, by running SQL Enterprise Manager:
-
Go to the SQL Enterprise Manager drop-down menu and select Server > SQL Server > Configure.
-
Select the Configuration tab.
-
Change the above-mentioned parameters accordingly, if necessary.
Figure 1: Server Configuration/Options
-
Once you have changed the values, Stop ICM Services.
-
Cycle the Microsoft SQLServer service.
-
Start ICM Services.
ICRDBA/ICMDBA
To check and change these values on any Cisco ICM Logger, Distributor AW, or HDS, run ICRDBA or ICMDBA:
-
Select Start > Run.
-
Type icrdba.exe for ICM version 4.1.x or icmdba.exe for ICM version 4.5.0 and later.
-
Click OK, to open ICRDBA or ICMDBA.
-
Highlight the desired hostname from the Servers list. If the desired hostname is not listed, select File > Add Server add the machine by hostname or IP address.
-
Select Server > Configure, to open the Configure dialog.
Figure 2: Configure
-
Select the checkboxes of the settings requiring changes.
-
Under the New column, type the new value for each setting.
-
When you are finished entering all of the changes, click OK.
-
ICRDBA or ICMDBA presents a dialog indicating SQL Server should be restarted.
-
Click Yes to continue.
Note: The ICM Distributor service is also cycled.
Related Information
| Updated: Jun 21, 2005 | Document ID: 23340 |