Question 34

Answer E is correct. sys.dm_db_index_usage_stats returns counts of different types of index operations and the time each type of operation was last performed. sys.dm_fts_index_population returns information about the full-text index populations currently in progress. sys.dm_exec_query_stats returns aggregate performance statistics for cached query plans. sys.dm_db_index_physical_stats returns size and fragmentation information. sys.dm_db_physical_stats returns page and row-count information.

For more information, see the following sources:

  • Chapter 8, "Troubleshooting and Optimizing SQL Server"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, System Views (Transact-SQL), Dynamic Management Views and Functions, Index Related Dynamic Management Views and Functions"

MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: