ybill |
---|
Glory, точно! Спасибо, этого вполне достаточно |
SELECT
DB_NAME(db.database_id) DatabaseName,
MAX(CASE WHEN ISNULL(s.last_user_seek, '1900-01-01') > ISNULL(s.last_user_scan, '1900-01-01')
THEN
CASE WHEN ISNULL(s.last_user_seek, '1900-01-01') > ISNULL(s.last_user_lookup, '1900-01-01')
THEN
s.last_user_seek
ELSE
s.last_user_lookup
END
ELSE
CASE WHEN ISNULL(s.last_user_scan, '1900-01-01') > ISNULL(s.last_user_lookup, '1900-01-01')
THEN
s.last_user_scan
ELSE
s.last_user_lookup
END
END) AS last_user_read,
MAX(last_user_update) AS last_user_update,
db.create_date AS db_create_date
FROM sys.databases db
LEFT JOIN sys.dm_db_index_usage_stats AS s ON s.database_id = db.database_id
GROUP BY DB_NAME(db.database_id), db.create_date
ORDER BY last_user_read, last_user_update