Multiple choice technology databases

Which DMV is used to identify fragmentation of Indexes

  1. sys.dm_os_schedulers

  2. sys.dm_exec_requests

  3. sys.dm_db_index_physical_stats

  4. sys.dm_db_index_usage_stats
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

sys.dm_db_index_physical_stats is the Dynamic Management View (DMV) specifically designed to return size and fragmentation information for indexes. It provides details like page count, average fragmentation percentage, and record count. sys.dm_os_schedulers is for OS schedulers, sys.dm_exec_requests shows executing requests, and sys.dm_db_index_usage_stats tracks index usage statistics.

Keep practicing — related questions