Is it a single performance issue or a general performance issue.
Reason I ask is a single issue could be a quick re-write of a SPROC or something.
A general issue could mean a lot more work, like investigating indexes, normalisation and all that jazz.