When you're sedated for a procedure, are you supposed to be asleep?

I was sedated for an upper scope recently. I wasn't unconscious. Is that normal? What is sedation supposed to be? I didn't feel like I could move, but I was fully alert for the whole thing.