I suppose when you're starting to get play on the crank for cartridge bearing BBs. Things like squeaking if caused by the BB is usually due to incorrectly torqued BB cups or did not grease the threads. But too often squeaks are caused by something else other than the BB even if it seems the noises are coming from the BB.
Other than problems, cartridge BB's can last a very long time. Over 10,000 miles at least even for low end cheap BBs.