I guess the question should become where is this “knock“ coming from can you pinpoint your source? A cheap set of “mechanics stethoscope “ might help you figure out where the actual noise is coming from; on high mileage engines many times the lifters get clogged up and get noisy. In that case, you might want to try running some product like seafoam; when added to the oil, this can really quiet things down and clean out, dirty, lifters, etc..
If you actually have a “rod knock”; the damage is already done with the bearings and it doesn’t matter what brand of oil you use, it won’t fix that problem.
A product like seafoam is relatively inexpensive and you can see if that helps with this particular noise, you are describing and it could be something like a Hydraulic stuck lifter, etc.