I have a wait performance script that can be run for short periods of time to estimate which user or database is consuming more resources, but it is still an estimate and does not indicate how much more could be done by the server. If the number of applications is not changing, it could be used to assign a relative weight for back billing customers.

The detailed approach via a trace can be very expensive on active systems, like an OLTP server.