I was running 7.1 OpsCenter as a VM and everything ran fine. 1 master server and it isn't the huge environment at all. I upgraded the OpsCenter 184.108.40.206 and was going to upgrade NBU itself later on. After the upgrade, the DB service on the opscenter server goes max CPU every 4-5 hours and stays there for an hour. It never did this before but it's pretty consistent now. Anyone else get this after the upgrade?
Check your ./installpath/OpsCenter/Server/db/log/server.log
Scroll towards the end of the log for mention of the word fragment.
I. 11/21 07:43:08. Performance warning: Database file "\database_path\vxpmdb.db" consists of 25 disk fragments
Check the number of fragments your vxpmdb.db file is using...
Anything in excesss of 200, I highly suggest running a defrag of the database.
No such warnings. However, ever since the upgrade, these happen consistently.
Checkpoints are normal, but there should be fragment message during the start of the vxpmdb in the server.log file.
Search the entire file for the keyword fragment.
Please post your results....
Although the databases are fragmented... this issue may just be related to resources / performance tuning.
How much RAM is allocated towards the VM?
In addition, you will want to review the following Technote to increase performance.
|Article: HOWTO42977|||||Created: 2011-03-06|||||Updated: 2011-03-06|||||Article URL http://www.symantec.com/docs/HOWTO42977