You should take a look at transaction management companies like Dynatrace and Correlsense. These can track application activity across several tiers. Correlsense is interesting since they install at the operating system level and can still tie the resource usage with the application. Haven't used either, so can't say how well they perform in production environments.