Ultimately this will depend on what is causing the engine noise. Some issues can be solved by using a thicker oil, which can help to prolong the life of older vehicles, as well as lubricate parts that have suffered from more wear and tear over the years.  However, if the noisy problem in your engine is down to the lifters, thicker oil is unlikely to solve the problem. This is because it will take longer for this thicker oil to warm up and reach all parts of the lifters, so it will stay louder for longer.  If in doubt, you should take your car to your local mechanic to see if they can identify the problem.