To create and configure a MS SQL Server 2000 database, follow the instructions in the sections below:
Additional Information
For descriptions of bracketed names (for example, <DBA name>), see Documentation Conventions.
To create a new MS SQL 2000 database:
Open the SQL Server Enterprise Manager Application
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.
Right click on Databases
and select New Database...
Enter
a Name for the database, for example
"ccs". Click OK to create
the database.
To assign a user to the new database:
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.
Right click on Users
and select New Database User...
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.
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).
Grants the following roles memberships to this user for the selected database:
db_owner
db_accessadmin
db_securityadmin
db_ddladmin
db_backupoperator
db_datareader
db_datawriter
Click OK to add the user to the database. You can now access this database from CCS using this users user name and password.
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 |
|
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 |
Calculation |
TOTAL |
[Number of agents] |
logins and logouts per day |
[Number of sessions per day] |
session size per day |
[Number of sessions per day] |
chat size per day |
[Number of sessions per day] |
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.