You may want to set up a simple profiler trace with just the RPC Completed, and T-SQL completed events being monitored. Run that for a while, then save the output to a table. You can do all sorts of analysis on the table. How many commands run per database, how many CPU ticks (roughly) per database, etc..