Situatie
Mai jos este un script ce listeaza toate bazele de date de pe un server MSSQL Server si, pentru acestea, afiseaza ultima data de accesare a fiecare bazei de date. Poate fi folosit pentru a vedea care sunt bazele de date ce nu mai sunt utilizate.
Solutie
SELECT [databasename],
MAX([lastaccessdate]) AS [lastaccessdate]
FROM
(
SELECT DB_NAME([database_id]) AS [databasename],
[last_user_seek],
[last_user_scan],
[last_user_lookup],
[last_user_update]
FROM [sys].[dm_db_index_usage_stats]
) AS [pivottable] UNPIVOT([lastaccessdate] FOR [last_user_access] IN([last_user_seek],
[last_user_scan],
[last_user_lookup],
[last_user_update])) AS [unpivottable]
GROUP BY [databasename]
HAVING [databasename] NOT IN(‘master’, ‘tempdb’, ‘model’, ‘msdb’)
ORDER BY 2 desc
Leave A Comment?