If you install Control Manager and its SQL server on the same machine, configure the SQL server to use a fixed memory size equivalent to two-thirds of the total memory on the server. For example, if the server has 256MB of RAM, set 150MB as the fixed memory size for the SQL server.
Install the Control Manager SQL database on the Control Manager server itself, or on a separate server (for example, a dedicated SQL server). If Control Manager manages over 1,000 products, Trend Micro recommends using a dedicated SQL server.
For instructions on how to manage SQL resources, and other sizing recommendations, refer to Microsoft SQL documentation.
See also:
Understanding the Control Manager database
Understanding Control Manager data storage
ODBC drivers
Authentication