I was a terrible sleeper until I started on Zyprexa (olanzapine) 10mg. Wasn't prescribed for sleep, but it was a nice side effect.

Ativan (lorazepam) also does it for me, but that's a benzo.