Get IO used per database

This code can be used to find out how many reads and writes each database have been using since last start of the sql server service. Can be used to e.g. determine candidates to be moved to other disks/luns

SELECT *,db_name(dbid)
FROM :: fn_virtualfilestats(-1, -1)
order by numberreads desc
go
SELECT *,db_name(dbid)
FROM :: fn_virtualfilestats(-1, -1)
order by numberwrites desc