A cartesian product in a single query can make the whole server go slow. The other problem is the result sets, which come back many multiples too big.
No gizmo tool will help you with a cartesian product. No query analyzer will tell you that you have a problem, or how to fix it. Cartesian products are one problem area that only observation, knowledge, and good SQL skills will overcome.