04-23-2012 02:51 AM
hi,
we have a Opscenter7.1.0.1 running on Windows 2008 standard R2 with 2 processors/8G.
it's a VM and houses the OpsCenter only.
Recently we received CPU high unilization alerts from this server........and we narrow down the issue to the NetBackup OpsCenter services, when stopped the CPU load goes down to a low level. ......
and besides I found the following warning in "D:\Program Files\Symantec\OpsCenter\server\db\log\server.log"
04/17 14:32:06. Performance warning: Database file "D:\Program Files\Symantec\OpsCenter\Server\DB\Data\vxpmdb.db" consists of 1248 disk fragments
04/17 14:32:07. Performance warning: Database file "D:\Program Files\Symantec\OpsCenter\Server\DB\Data\symcOpscache.db" consists of 292 disk fragments....
it seems we need to defrag the Opscenter databases so as to increase data access and retrieval speed...I am not sure..but I wanted to try it since our OpsCenter has been running for about 10 months and manages 7 masters...the database must be very large....
my question is that :
1)how to defrag the database ? is that mean we need to purge some obsolete data?
2)I ran the "dbdefrag" today but I didn't see any change via the server.log ..so I ran it 3 times.......and after I ran this command what else do I need to do ?
after defragmentation, how long is the data kept in Opscenter databases?
D:\Program Files\Symantec\OpsCenter\server\bin>dbdefrag
Stopping the OpsCenter Web Console Service...
Stopping the OpsCenter Server...
Stopping the OpsCenter Database...
Terminate batch job (Y/N)? Y
D:\Program Files\Symantec\OpsCenter\server\bin>dbdefrag
Stopping the OpsCenter Web Console Service...
Stopping the OpsCenter Server...
Stopping the OpsCenter Database...
Error in Export of vxpmdb
Starting the OpsCenter Database...
Starting the OpsCenter Server...
Starting OpsCenter Web Console Service...
D:\Program Files\Symantec\OpsCenter\server\bin>dbdefrag
Stopping the OpsCenter Web Console Service...
Stopping the OpsCenter Server...
Stopping the OpsCenter Database......
sorry about so many questions...I am lost with this defragmentation
Solved! Go to Solution.
04-24-2012 01:35 AM
It does the data purge each day at the time shown in the bottom box on the data purge screen - i believe this defaults to 00:00 (midnight) so once that time has passed the data will be nicely purged and you can run your defag.
04-23-2012 03:09 AM
All of your commands look fine - the amount of data kept in OpsCenter is controlled in the Settings - Configuration - Data Purge
If you want to change any of these then do so, wait until after the "time of purge" and then defrag the database to tidy things up.
Also be careful when you finally upgrade as there is an issue in 7.1.0.3 where is starts to use only one processor - this is what i thought may be your issue but you say you are on 7.1.0.1 (maybe worth a check anyway - http://www.symantec.com/docs/TECH178219)
On a standard install the reports work for 60 days, on analytics for as log as you like - however the data is kept pretty much forever depending on what you pruning settings are
Hope this helps
04-23-2012 08:24 PM
hi, Mark thanks for your reply
our opscenter version is indeed 7.1.0.1 (Build 20110612)..
So let me make it clear:
I need to do the "Data Purge" via OpsCenter GUI first and then run the "dbdefrag" to tidfy things up..................right?
04-23-2012 08:31 PM
and by the way, it prompted that "Data Purge Configuration updated successfully"...
but when will the OpsCenter do the Data Purge? does it have a default schedule for this?
04-24-2012 01:35 AM
It does the data purge each day at the time shown in the bottom box on the data purge screen - i believe this defaults to 00:00 (midnight) so once that time has passed the data will be nicely purged and you can run your defag.
04-26-2012 09:44 PM
thanks mark
04-27-2012 10:13 AM
Data Purge will process (by default) at 12:00am each day.
However, it will also kick off when you restart OpsCenter Database, if the purge is due to run.
You can check the purge-status.log to determine when and how much information is removed from the database.
./installpath/OpsCenter/Server/log/purge-status.log