Matt Crowley (11/6/2013)
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..
If this is a production machine make sure you run it as a server side trace. http://technet.microsoft.com/en-us/library/cc293613.aspx