Start with this two-part series. Finding the problem is more than half the battle.
I doubt there's a single, comprehensive site that covers everything. The links given earlier are good but that's far from everything. Read blogs, articles and performance questions here. Grant Fritchey's book (link in his sig) is a very good resource.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability