M.G.
My son had one done at around 2 years old. He was given a cocktail to drink to calm him that he refused to fully finish. He was also given an IV to sedate him during the procedure. My child has a sleep disorder to where he would not willing sleep even after 2 days of sleep deprivation. Yes, I did do this on our doctor's recommendation. Our procedure lasted about an hour from start to finish. I remained in the room the entire time both before and after said procedure. Once the procedure was finished he awoke within minutes and was quite groggy. He of course was also unsteady on his feet. Prior to leaving it was imperative that he take in fluids so I already had a sippy cup with apple juice for him to drink.
Our case isn't typical. My son is autistic and at the time was nonverbal. It was not a traumatic experience and he did not even fight the IV. It was more nerve-wracking for me. All in all it isn't what I would consider a horrible procedure.
Best of luck to you and yours.