cancel
Showing results for 
Search instead for 
Did you mean: 

High CPU usage after upgrading to 7.1.0.2

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 7.1.0.2 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?

5 Replies

Check your

Check your ./installpath/OpsCenter/Server/db/log/server.log

Scroll towards the end of the log for mention of the word fragment.

Example: 

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.

http://www.symantec.com/docs/HOWTO42823

No such warnings. However,

No such warnings. However, ever since the upgrade, these happen consistently.

 

 

I. 11/23 08:01:25. Starting checkpoint of "vxpmdb" (vxpmdb.db) at Wed Nov 23 2011 08:01
I. 11/23 08:01:25. Finished checkpoint of "vxpmdb" (vxpmdb.db) at Wed Nov 23 2011 08:01
I. 11/23 09:01:26. Starting checkpoint of "vxpmdb" (vxpmdb.db) at Wed Nov 23 2011 09:01
I. 11/23 09:01:27. Finished checkpoint of "vxpmdb" (vxpmdb.db) at Wed Nov 23 2011 09:01
I. 11/23 09:27:37. Starting checkpoint of "vxpmdb" (vxpmdb.db) at Wed Nov 23 2011 09:27
I. 11/23 09:27:37. Finished checkpoint of "vxpmdb" (vxpmdb.db) at Wed Nov 23 2011 09:27

Checkpoints are normal, but

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....

 

  I. 11/14 15:57:28. Starting

 

I. 11/14 15:57:28. Starting database "vxpmdb" (D:\Program Files\Symantec\OpsCenter\Server\DB\Data\vxpmdb.db) at Mon Nov 14 2011 15:57
I. 11/14 15:57:28. Performance warning: Database file "D:\Program Files\Symantec\OpsCenter\Server\DB\Data\vxpmdb.db" consists of 56 disk fragments
I. 11/14 15:57:29. Opening dbspace 'symcOpscache' in file 'symcOpscache.db' for database 'vxpmdb'
I. 11/14 15:57:29. Performance warning: Database file "D:\Program Files\Symantec\OpsCenter\Server\DB\Data\symcOpscache.db" consists of 157 disk fragments

Database Fragments....

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.

 

About tuning OpsCenter for more performance

Article: HOWTO42977  |  Created: 2011-03-06  |  Updated: 2011-03-06  |  Article URL http://www.symantec.com/docs/HOWTO42977