I've struggled with this one myself, as I am a huge music fan. In the past, drinking at shows would go without saying. It's a big difference sober. I've had to accept that that part of the experience is gone. It's difficult, but there are advantages. I remember every live show, so that's a big one. I go and have a nice meal and a coffee before the show. The best part is waking up the next morning knowing that sobriety has not been compromised.
Be sure to eat plenty when you're there. That will lessen the chances of cravings. Take or buy plenty of treats like sweets, good food, etc. So you'll have something to enjoy/ heighten the experience. Pull up SR before, during and after. And if you think that your sobriety won't survive the concert experience, don't go.