if you want separate tones per say, messaging and email,
open up the messages app and hit the menu button and go to settings there and you can change the tone for texts, its the same process for the gmail app as well.
the way i have it setup is one tone for texts and one for email, since my emails are the most ignored of the 2.