Hi All,
I am in process of upgrading BigFix application from 10.0.9 to 10.0.11 and have a BFEnterprise DB of 297 GB. I see that re-indexing job has taken almost an hour and still continuing, it looks to me that it may take longer but is it expected behavior or we can do something to make it faster, Please suggest!!
Screenshot:-
Regards,
VT
It may take a long time to finish reindexing but should not be interrupted.
For next time,you should check general SQL tuning, like memory allocation, disk speed, etc.
If you have a DSA server or a standalone WebUI or Web Reports, you can shut down those services during upgrade to make sure they are not interfering with SQL performance.
Thanks a LOT Jason,
for sure we will check the SQL tunning in forthcoming upgrades. We don’t have DSA though but as of now we should wait for it to complete.
Regards,
VT
Also worth noting that if you do not run any housekeeping to remove old content from the tables (via the BESAdmin util), that can mean you have much more data to be re-indexed which can make upgrades take longer. One of our upgrades took longer that I expected and I later discovered a contributing factor was the housekeeping of duplicate/delete computer and deleted actions had stopped and we had a large build up of redundant records.
