Tool to troubleshoot performance problems

We are evaluating the usefulness of Management Console. It doesn't seem to be helpful as far as troubleshooting performance problems. Does anyone have any tools that they use to try to solve these problems? We're running BPC 7.0 SP4 on SQL 2008. Thanks.