What should you do to determine the dynamic management view that should be used?

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 encompass administrating the SQL Server 2005 database named Certkiller -DB01.
Certkiller -DB01 contains a table that consists of a number of indexes. It has come to your attention that data modification performance has degraded and that some of the indexes are not used. You have received instruction from the CIO to determine which indexes are not used by queries since the last time Certkiller -DB01 started. You need to determine the dynamic management view that should be used.
What should you do?

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 encompass administrating the SQL Server 2005 database named Certkiller -DB01.

Certkiller -DB01 contains a table that consists of a number of indexes. It has come to your attention that data modification performance has degraded and that some of the indexes are not used. You have received instruction from the CIO to determine which indexes are not used by queries since the last time Certkiller -DB01 started. You need to determine the dynamic management view that should be used.

What should you do?

A.
You should use the sys.dm_db_index_usage_stats management view to determine which queries were not used.

B.
You should use the sys.dm_fts_index_population dynamic management view.

C.
You should use the sys.dm_db_index_physical_stats management view to determine which queries were not used.

D.
You should use the sys.dm_exec_requests dynamic management view.

Explanation:
The sys.dm_db_index_usage_stats dynamic management view holds the core statistics regarding every index within a database. You make use of this view to find the number of seeks, scans, lookups or updates that have occurred with an index. You can determine the last time an index was used by examining the last_user_seek, last_user_scan as well as last_user_lookup columns.



Leave a Reply 0

Your email address will not be published. Required fields are marked *