Understanding the Control Manager Database

Control Manager uses the Microsoft SQL Server database (db_ControlManager.mdf) to store data included in logs, Communicator schedule, managed product and child server information, user account, network environment, and notification settings.

The Control Manager server establishes the database connection using a System DSN ODBC connection. The Control Manager installation generates this connection as well as the ID and password used to access db_ControlManager.mdf. The default ID is sa. Control Manager encrypts the password.

To maximize the SQL server security, configure any SQL account used to manage db_ControlManager with the following minimum permissions:

  • dbcreator for the server role

  • db_owner for the db_ControlManager role

Logs from managed products contribute to database expansion. Managed products send various log types to Control Manager. Trend Micro measures the database size of the following common log types:

  • Virus logs

  • Spyware logs

  • Web Security logs

  • Content Security logs

Refer to the following table to obtain the database size:

Table 1. Log Count and Database Size

Log Type

Log Count

Database Size (MB)

Virus

100,000

156

500,000

667

1,000,000

1,191

Spyware

100,000

156

500,000

770

1,000,000

1,570

Content security

100,000

121

500,000

543

1,000,000

1,263

Web security

100,000

99

500,000

562

1,000,000

1,106

The database space required for log storage can be calculated based on the log type and amount. For example:

- An OfficeScan managed product sends 20,000 virus logs and 10,000 web security logs to Control Manager daily.

- Control Manager keeps both log types for 90 days.

The database space required is 1.2 GB for virus logs and 1 GB for web security logs. However, there might be an additional space required for log summary or other features.

Because the Control Manager database runs on a scalable database — SQL Server, the theoretical limit is whatever the hardware can handle. Trend Micro has tested up to 2,000,000 entries. If the database server performance is overworked or pushed to its limit, the web console may experience connection time-outs.

Tip:

Trend Micro recommends allocating a significant buffer space for database growth and monitoring the database to help obtain a precise database size measurement.