SQL Server - Averiguar ultima lectura y escritura de una base de datos

SELECT d.name,

last_user_seek = MAX(last_user_seek),

last_user_scan = MAX(last_user_scan),

last_user_lookup = MAX(last_user_lookup),

last_user_update = MAX(last_user_update)

FROM sys.dm_db_index_usage_stats AS i

JOIN sys.databases AS d ON i.database_id=d.database_id

GROUP BY d.name

select

    UNPVT.[DataBase]

    ,MaxLastUse     = max(UNPVT.MaxLastUse)

from

   (

    select

        [DataBase], last_user_seek, last_user_scan, last_user_lookup, last_user_update

    from

        (

            select

                [DataBase]          = DB.[name]

                ,last_user_seek     = max(IU.last_user_seek)

                ,last_user_scan     = max(IU.last_user_scan)

                ,last_user_lookup   = max(IU.last_user_lookup)

                ,last_user_update   = max(IU.last_user_update)

            from

                sys.databases as DB

                inner join sys.dm_db_index_usage_stats as IU on

                    IU.database_id = DB.database_id

            group by

                DB.[name]

        ) as DBIU

    ) as P unpivot (MaxLastUse for ColumnName in (last_user_seek, last_user_scan, last_user_lookup, last_user_update)) as UNPVT

group by

    UNPVT.[DataBase]

order by

    UNPVT.[DataBase]