Cisco Cisco Administrative Workstation Guía De Instalación

Setting maximum file size is important because database file growth may 
potentially use all the disk space and can cause system-wide problems. If 
the database files are on the system disk (for example C:), it is 
recommended that the size of all database files should not be over 80% of 
all the disk space because running out of disk space on the system disk is 
not a desirable scenario. It is also important to remember that there can be 
many databases on a single database server and many disk files on a 
single disk. Each data file should only use its share of disk to avoid 
running out of disk space. This setting is based on your configuration and 
is up to you to do the calculation for the limits.

Verify correct sizing of each database.

Databases include: ICM logger DB, AW DB, or HDS DB (depending on ICM 
node)

tempdb should be at least 100 MB

master db should be at least 50 MB

Verify correct sizing of the transaction log for each database.

Databases include: ICM logger DB, AW DB, or HDS DB (depending on ICM 
node)

Under the transaction log tab for each database, disable auto-grow.

It is recommended that transaction log in ICM system to be kept under 
500M to allow rapid recovery in case of restarting the system. Even 
though the database files are allowed to automatically grow, the size of 
the transaction log growth should be changed manually.

ICM logger DB, AW DB, or HDS DB transaction log (depending on ICM 
node).

tempdblog should be at least 20 MB

master db log should be at least 20 MB

Do not change anything under the Permissions tab. 

Select the Options tab and set the options as follows:

ANSI NULL default: No