Really cool place to be over the summer. They have sand, and the pool has waves. The only thing that would prevent me from going is the crowd. Too many people in one place is a spell for disaster. Nonetheless, we went over here to a concert, and it was perfect. You stand at the pool, and if you feel like hanging out back, you can take a seat on the sand. Unless you're standing, I think you'll have a good spot for your concert so long as no one decides to be rude and stand in front of you.
I'm a huge fan of this venue, and I think I'll be going more often especially for concerts. My only advice, try to seat close to the front when the sand is so no one can obscure your view. Also, buy the coconut at their shop. It's a nice touch for going to the "beach".