How do you see which database on a Server uses most resources I have a database server with a couple of databases on it. How can I see where any resource pressure may come from?

I would like to get a table of:


Database Name   
Batch Requests per second
CPU Time
Logical Read 
Logical Writes
Only some resources can be tracked to databases. IO and buffer pool usage can clearly be tracked to a database:


IO usage: sys.dm_io_virtual_file_stats
Buffer pool usage: sys.dm_os_buffer_descriptors


The query execution statistics (like logical reads) can be attributed to queries, but cannot be associated (correctly) with a database because queries can (and often do) span databases. sys.dm_exec_query_stats is the main entry point for these stats.