Hi.
I just had one done last week, and had what they call "twilight" anesthesia...
I was somewhat awake throughout it. My doctor took biopsies from both sides of my hips. The only discomfort was some slight "digging/pushing" to get what he needed...and some minorly small discomfort for about a day---nothing Tylenol didn't help. It was not nearly as bad as I was expecting. That's one thing about this forum....people have "been there/done that" & are very informative.
I've been through test after test, too....Think of it as a "good thing." You want a thorough doctor---one who catches everything...(borderline problems down-the-road.) You must be in good hands.
Good luck.

S.