To be sleepy is to be tired. You might be sleepy because you're tired from work, or you might be sleepy because you're tired from a night of partying.
- He felt sleepy after dinner, and decided to go to bed.
- She was so sleepy that she didn't even notice when the party ended.