The most common prescription insomnia medicine is a sedating antidepressant called trazodone, even though there’s no good evidence that it offers more than a two-week benefit, and it comes with side effects.