Hi ellen,
My son's psychiatrist prescribed him ativan (.5mg) to use on an occasional basis if his behaviors get too out of control, since it's not something he takes on a daily basis, I've not noticed him becoming sleepy on the medication. To help him sleep he's taking Trazodone, which is non addictive, the ativan is addictive.
Now for me, I'm supposed to take ativan (.5mg) twice a day for anxiety, it does make me tired. For sleep they have me on Ristoril.
Sorry I can't be of more help, but am sure others know more about the various medications.