A good indication that a car needs a new transmission is if the RPMs increase dramatically when the car isn't moving. Be aware of car's with automatic transmissions that have trouble making it to second gear with tips from a certified master mechanic in this free video on car maintenance.
