Notes up to harmonic A can crop up occasionally - there’s a big band arrangement of Harlem Nocturne that finishes on it - so it’s useful to have.
Other than that it’s solo stuff really and that is up to you of course.
If you’re confident up there, D is as high as most go - Sanborn frequently used it, but I’ve not heard him play higher.
Rock players do play higher, especially on tenor. Ray Beavis plays up to super G, and I’m not talking about a “blow ‘n’ hope” squeak. I’ve heard him use it in gigs - though it’s too high for me to have any sort of confidence with.
Brandon Fields also frequently plays above D with absolute control and a nice sound - but he’s a freak!
So echo what Pete said although up to A is handy to have.