Reads and Writes

    SELECT
        DB_NAME(database_id)    AS "DB",
        num_of_reads            AS "Reads",
        num_of_bytes_read       AS "Bytes Read",
        file_id                 AS "File"

    FROM sys.dm_io_virtual_file_stats(NULL, NULL)

    ORDER BY
        num_of_bytes_read DESC;

    SELECT
        DB_NAME(database_id)    AS "DB",
        num_of_writes           AS "Writes",
        num_of_bytes_written    AS "Bytes Written",
        file_id                 AS "File"

    FROM sys.dm_io_virtual_file_stats(NULL, NULL)

    ORDER BY
        num_of_bytes_written DESC;