It may not be the answer you are looking for. I dont think there is a magic tool that will tell you all the problems in all the framework you are using.
I am interested in lower database query time.
For this, you have to use Sql profiler and go through each procedure/query then optimize.
How to render pages more quickly.
Try YSlow from Yahoo. I cant remember tool name from Google. I will add it latter
Check out Hanselmans podcast with Steve Sodders. Creator of YSlow on Web Site Optimization. They talk about various tools on performance tuning.
Sam Saffron works at Stack Overflow and writes numerous articles on performance tuning. This one may be useful for you. Profiling your website like a true Ninja
That's all said, logging is going to be your friend. With good logging, you have more freedom to focus on specific code/component or with AOP tools you can instrument entire app with little code.