Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

High CPU usage after upgrading to 7.1.0.2

Created: 21 Nov 2011 | 5 comments
nxu's picture
nxu
0 0 Votes
Login to vote

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?

Discussion Filed Under:
, , , ,

Comments

tom_sprouse's picture
21
Nov
2011
0 Votes 0
Login to vote
tom_sprouse
Symantec Employee
Certified

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

Note: If this post provides you with a solution don't forget to mark the discussion as solved&l

nxu's picture
23
Nov
2011
0 Votes 0
Login to vote
nxu

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
tom_sprouse's picture
30
Nov
2011
0 Votes 0
Login to vote
tom_sprouse
Symantec Employee
Certified

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

 

Note: If this post provides you with a solution don't forget to mark the discussion as solved&l

nxu's picture
05
Dec
2011
0 Votes 0
Login to vote
nxu

  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
tom_sprouse's picture
07
Dec
2011
0 Votes 0
Login to vote
tom_sprouse
Symantec Employee
Certified

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
 

Note: If this post provides you with a solution don't forget to mark the discussion as solved&l

Technical Support

Symantec.com

Store

Community Stats

Total Content Items
Members
270,012