The OpsCenter database (dbsrv11.exe) maxes out the CPU. I have allocated 6 cores just to the database, and they are running 100% continuously. I have done all the obvious stuff: defrag disk, defrag database, increase cache (32GB), add processors. The only thing that quiets the database is disabling data collection for 4 of my 7 appliances, the other masters do not seem to affect performance as much. I already opened a case, but support seems clueless about the database. Has anyone had this problem on 7.5.0.6?

HI MIlan, How large is your database and how many JOBS per day are you pulling into OpsCenter? 7.5.0.6 had some DB and performance enhancements that even our very large customers are liking. I am worried that six cores simply isnt enough. Is this running on a VM? Not really something we recommend as it requires a lot more resources just to do a basic job. The fact that you can disable some of your appliances and performance improves tells me you may be overloading the system. Thanks, dave

Hello Dave, It is a standalone system, octacore, 48GB, dedicated to OpsCenter, no VM, with 30GB database and 25.000 jobs per day. Thanks for your input, that is new info for me, as I was under the impression that we had a decently configured machine for OpsCenter purposes. We are going to scale up soon, so I am hoping this will help. However, what sort of system would we need if we added, say, a hundred appliances? It is interesting that the other NBU Masters do not seem to have such an impact, as the Appliances, but maybe it is due to the nature of the job mix that we have on the Appliances. Milan

Dave, I should also add that it is not just overload from too many queries, the processors are running 100% continuously. It looks as you would expect from a long running query or a full scan of the database. Regards, Milan

Ya, that is a monster system for only 25k jobs per day. Keep the support case open and force it into backline. All our other customers who have upgraded have been very pleased with the performance. This is the first I have heard of issues. Let me ping my technical guys on the Appliance question. I know if you have 100 Masters running 1000 jobs each that isnt a big deal (100,000 jobs total) so not sure how an Appliance Master would change anything. Would all the appliances be Masters in your scenario? Thanks, dave

Hello Dave, Yes, thanks for the advice. I read about such a problem in 7.5.0.5, we had an EEB to deal with it. However, that was folded into 7.5.0.6. I am also thinking that maybe all the upgrades we have done have left so garbage in the database that is causing this behaviour. It would be nice to do a clean install and try it out, but we need the history. Wish you a nice weekend ! Milan

OpsCenter 7.5.0.6 database maxes out

13 Replies

MilanPalian-A
Level 3
12 years ago
Just for closure ...

We ended up upgrading to OpsCenter 7.6 and significantly beefing up the hardware. The problem went away and surprisingly, CPU usage is now lower. Instead of many maxed out cores, there are only two and the rest of the load is spread around more thinly. It seems it was a case of resource starvation, causing an even bigger resource grab that OpsCenter could not handle gracefully.

OpsCenter 7.6 also has a newer version of SQL Anywhere (v12) which is also more responsive. I would recommend upgrading. There is an upgrade hitch that is documented in Technote TECH211070 , read it before upgrading.

- Milan
D_Thomas
Level 4
12 years ago
If you have this issue, just upgrade to 7.6

I had the same issue with 7.5.0.7 (after I had the problem with 7.5.0.6). I would just reboot the VM every other day to get around it, but the box would just consume any processors assigned to it for no reason that I could see.

I upgraded to 7.6.0.1 a few days ago, which is backwards compatible with the Netbackup servers running 7.5.0.6, and its been great ever since.
MilanPalian-A
Level 3
12 years ago
@DThomas,

Yes, we are also running 7.6 and it is much better, due to the newer database software.

However, we still had instances of cores stuck at 100% until someone from engineering who was participating in the WebEx manually regenerated the statistics on one of the database tables.

Forum Discussion

OpsCenter 7.5.0.6 database maxes out

13 Replies

Related Content

OpsCenter database backup

OpsCenter database backup

Server.conf file in Symantec Opscenter 7.5.0.6

Database Logins for OpsCenter

Delete from Opscenter Database