MS SQL Server 2000

To create and configure a MS SQL Server 2000 database, follow the instructions in the sections below:

  1. Create a MS SQL 2000 Database

  2. Assign a User to the Database

Additional Information

For descriptions of bracketed names (for example, <DBA name>), see Documentation Conventions.

Create a MS SQL 2000 Database

To create a new MS SQL 2000 database:

  1. Open the SQL Server Enterprise Manager Application

  2. Drill-down and select the Microsoft SQL Server > SQL Server Group > <Database Server> on which you want to create your CCS database. Expand the <Database Server> tree.

  3. Right click on Databases and select New Database...

  4. Enter a Name for the database, for example "ccs". Click OK to create the database.

Top

Assign a User to the Database

To assign a user to the new database:

  1. Drill-down and select the Microsoft SQL Server > SQL Server Group > <Database Server> > <CCS DB name> that you just created. Expand the <CCS DB name> tree.

  2. Right click on Users and select New Database User...

  3. Select one of the Login names from Login name. If you want to create a new user for this database select <new> and consult the MS SQL Server documenting on creating a new user, otherwise select on of the existing database login names.

  4. Enter a User name for the user, or use the default name provided (normally the default user name provided is that same as the Login name that you selected).

  5. Grants the following roles memberships to this user for the selected database:

  6. Click OK to add the user to the database. You can now access this database from CCS using this users user name and password.

Top

Calculate Database Size

Your database sizing requirements will depend on the behavior of your customer service agents.  We suggest that you contact customer support for database sizing recommendations.

Please complete the following table before contacting customer support.

 

Estimate the number of ...

Estimate

Logins and logouts per agent per day

 

Sessions per day (all agents)

 

Chat messages per session

 

Shared URLs per session

 

Agents active each day

 

Days to retain data

 

Database Sizing Example

The figures below are included as examples only.  Contact customer support for sizing information specific to your database configuration.  

 

Event

Memory Allocation

Agent login

320 bytes

Agent logout

320 bytes

Agent session

2200 bytes

Average size of a chat message

100 bytes

Average size of a shared URL

100 bytes

Calculations

 

Calculation

TOTAL

[Number of agents]
* [Number of logins and logouts per day]

logins and logouts per day

[Number of sessions per day]
* [Agent session size]

session size per day

[Number of sessions per day]
* [Number of chat messages per session]
* [Average size of a chat message]

chat size per day

[Number of sessions per day]
* [Number of shared URLs per session]
* [Average size of a shared URL]

shared URL size per day

Add the per-day totals and multiply by the [Days to retain data].

Allocate additional memory for static agent data.

Top