You need to perform the following maintenance tasks:

DRAG DROP
You have a database named database1. Each table in database1 has one index per column.
Users often report that creating items takes a long time.You need to perform the following maintenance tasks:
Identify unused indexes.
Identify which indexes should be created.
What should you use?
To answer, drag the appropriate function to the correct management task in the answer area. (Answer choices
may be used once, more than once, or not at all.)
Select and Place:

DRAG DROP
You have a database named database1. Each table in database1 has one index per column.
Users often report that creating items takes a long time.You need to perform the following maintenance tasks:
Identify unused indexes.
Identify which indexes should be created.
What should you use?
To answer, drag the appropriate function to the correct management task in the answer area. (Answer choices
may be used once, more than once, or not at all.)
Select and Place:

Answer:

Explanation:
Box 1: sys.dm_db_index_usage_stats
sys.dm_db_index_usage_stats shows you how many times the index was used for user queries. It returns
counts of different types of index operations and the time each type of operation was last performed in SQL
Server.
Box 2: sys.dm_db_missing_index_details
sys.dm_db_missing_index_details returns detailed information about a missing index; for example, it returns
the name and identifier of the table where the index is missing, and the columns and column types that should
make up the missing index.
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/
sys-dm-db-index-usage-stats-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-indexes-transact-sql
https://technet.microsoft.com/en-us/library/ms345524(v=sql.105).aspx



Leave a Reply 0

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