When we are rinsing off the dishes for the dishwasher and the sink water is running, a loud "whining" noise comes out of the pipes. What causes that and what can we do to stop it?

Is this hot, cold or both? What type of faucet, single leaver or two handle?