Adjusting the OpsCenter database service cache size
The amount of memory that is available for the database server service cache is an important factor in controlling OpsCenter performance. Veritas recommends that you adjust the Sybase cache size after installing OpsCenter. After you install OpsCenter, the database size can grow rapidly as you add more NetBackup Master Servers in OpsCenter.
See About adjusting the heap size or cache size for OpsCenter services.
Note:
The information that is published in this section is based on the tests that were performed in Veritas Lab in a controlled environment with expert users. These can only be used as guidelines and should not be used as 100% accurate benchmarks.
OpsCenter Sybase database automatically adjusts the cache size for optimum performance. You can also set the cache size using the -ch server option in the server.conf file.
It is recommended to set the -ch size to a higher value in the following scenarios:
If you have manually changed the -ch value and by monitoring the
server.conffile you have observed that the maximum cache size is consistently used, consider adjusting -ch to a higher value.For large databases with large number of database activities, the -ch value may need to be set to 50% (or higher) of the combined size of the database files on disk
For example, if the combined size of the database files is 100 GB, the -ch value may need to be increased to 50G (or higher).
Note:
The database files comprise the following files:
symcOpscache.db,symcopsscratchdb.db,symcsearchdb.db, andvxpmdb.db
To set the cache size using the -ch server option on Windows
- Open the
INSTALL_PATH\OpsCenter\server\db\conf\server.conffile.Note:
Save a copy of the
server.conffile before modifying it.The following default options appear in the
server.conffile:-n OPSCENTER_<HOST_NAME> -x tcpip(LocalOnly=YES;BROADCASTLISTENER=0; DOBROADCAST=NO;ME=127.0.0.1;ServerPort=13786) -gd DBA -gk DBA -gl DBA -gp 4096 -ti 0 -c 256M -ch 1024M -cl 256M -zl -os 1M -m -o "<INSTALL_PATH>\OpsCenter\server\db\log\server.log"
-c 256M indicates the initial memory that is reserved for caching database pages and other server information. The default value is 256 MB.
-cl 256M indicates the minimum cache size, as a limit to automatic cache resizing. The default minimum cache size is 256 MB.
-ch 1024M indicates the maximum cache size, as a limit to automatic cache growth. The default maximum cache size is1024 MB.
For example, to increase the initial and minimum cache sizes to 1024 MB and the maximum size to 4 GB, replace -c 256M -ch 1024M -cl 256M with -c 1024M -ch 4G -cl 1024M -cs in the sample
server.conffile:-n OPSCENTER_<HOST_NAME> -x tcpip(LocalOnly=YES;BROADCASTLISTENER=0; DOBROADCAST=NO;ME=127.0.0.1;ServerPort=13786) -gd DBA -gk DBA -gl DBA -gp 4096 -ti 0 -c 256M -ch 1024M -cl 256M -zl -os 1M -m -o "<INSTALL_PATH>\OpsCenter\server\db\log\server.log"
should be changed to
-n OPSCENTER_<HOST_NAME> -x tcpip(LocalOnly=YES;BROADCASTLISTENER=0; DOBROADCAST=NO;ME=127.0.0.1;ServerPort=13786) -gd DBA -gk DBA -gl DBA -gp 4096 -ti 0 -c 1024M -ch 4G -cl 1024M -zl -os 1M -m -o "<INSTALL_PATH>\OpsCenter\server\db\log\server.log"
In the same manner, to increase the initial and minimum cache size to 1 GB and the maximum cache size to 2 GB, you should change -c256M -ch 512M -cl 256M to -c 1G -ch 2G -cl 1G -cs in the
server.conffile.The -cs option logs the cache size changes for the database server.
You can verify the change in the cache size in the following file:
<INSTALL_PATH>\server\db\log\server.logfile. - Save the
server.conffile. - Stop and restart the OpsCenter services, as follows:
INSTALL_PATH\OpsCenter\server\bin\opsadmin.bat stop
INSTALL_PATH\OpsCenter\server\bin\opsadmin.bat start
To set the cache size using the -ch server option on UNIX
- Open the
<INSTALL_PATH>/SYMCOpsCenterServer/db/conf/server.conffile and change the value of the -ch option.Note:
Save a copy of the
server.conffile before modifying it.The following default options appear in the
server.conffile:-n OPSCENTER_<HOST_NAME> -x tcpip(LocalOnly=YES;BROADCASTLISTENER=0; DOBROADCAST=NO;ME=127.0.0.1;ServerPort=13786;) -gd DBA -gk DBA -gl DBA -gp 8192 -ti 0 -c 256M -ch 1024M -cl 256M -zl -os 1M -m
-c 256M indicates the initial memory that is reserved for caching database pages and other server information. The default value is 256 MB.
-cl 256M indicates the minimum cache size, as a limit to automatic cache resizing. The default minimum cache size is 256 MB.
-ch 1024M indicates the maximum cache size, as a limit to automatic cache growth. The default maximum cache size is 1024 MB for 64-bit systems.
For example, to increase the cache size to 1024 MB with a maximum of 4GB, replace -c 256M -ch 1024M -cl 256M with -c 1024M -ch 4G -cl 1024M -cs in the sample
server.conffile:-n OPSCENTER_<HOST_NAME> -x tcpip(LocalOnly=YES;BROADCASTLISTENER=0; DOBROADCAST=NO;ME=127.0.0.1;ServerPort=13786;) -gd DBA -gk DBA -gl DBA -gp 8192 -ti 0 -c 256M -ch 1024M -cl 256M -zl -os 1M -m
should be changed to:
-n OPSCENTER_<HOST_NAME> -x tcpip(LocalOnly=YES;BROADCASTLISTENER=0; DOBROADCAST=NO;ME=127.0.0.1;ServerPort=13786;) -gd DBA -gk DBA -gl DBA -gp 8192 -ti 0 -c 1024M -ch 4G -cl 1024M -zl -os 1M -m
This example replaced -c 256M -ch 1024M -cl 256M with -c 1024M -ch 1G -cl 1024M -cs in the
server.conffile to increase the initial and minimum cache size to 1024 MB with a maximum of 4 GB.In the same manner, to increase the initial and minimum cache size to 1 GB and a maximum of 2 GB, you should change -c256M -ch 1024M -cl 256M to -c 1G -ch 2G -cl 1G -cs in the
server.conffile.The -cs option logs the cache size changes for the database server.
You can verify the change in the cache size in the following file:
INSTALL_PATH/SYMCOpsCenterServer/db/log/dbserver.logfile. - Save the
server.conffile. - Stop and restart the OpsCenter processes, as follows:
INSTALL_PATH/SYMCOpsCenterServer/bin/opsadmin.sh stop
INSTALL_PATH/SYMCOpsCenterServer/bin/opsadmin.sh start