You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of the SQL Server computers. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 contains a table that contains of quite a few indexes. During routine monitoring you notice that data modification performance has degraded. You also believe that some of the indexes are not used. You want to identify which indexes have not been used by any queries since the last time Certkiller -DB01 has started
What should you do?
A.
Use the sys.dm_fts_index_population dynamic management view.
B.
Use the sys.dm_exec_requests dynamic management view.
C.
Use the sys.dm_db_index_usage_stats dynamic management view.
D.
Use the sys.dm_db_index_physical_stats dynamic management view.
Explanation:
The sys.dm_db_index_usage_stats dynamic management view contains core statistics about each index within a database. If you want to find the number of seeks, scans, lookups, or updates that have occurred with an index, you should use this view. You can determine the last time an index was used by examining the last_user_seek, last_user_scan and last_user_lookup columns.