Such tool for profiling most of the tiers will be very paid
I suggest that you go for the DB scripts suggested by Neo in the previous post, and use apache's Jmeter for web profiling - very good alternative to the paid ones. OpenSTA is also a good tool, according to my colleagues, but personally I haven't used it.