Different notification sounds for sms and email?
You can customize the Notification settings for both Gmail and Messaging in each of the apps separately.

In Gmail press menu and go to More->Settings and look at the Notification settings section.

In Messaging press menu then Settings and look at the Notification settings section.