• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

  • Filip Holub

How to identify Index Fragmentation?

If you want to find out fragmentation of index your database you have several options. In my case is the best Dynamic Management View "sys.dm_db_index_physical_stats". This system view returns informations about fragmantation in percent, types of index, number of data pages and etc. This DMV can help to build a regular index maintenance.

Syntax is very simple, just use select from the system view:

The result looks like this:

(click on the picture for max size)

This DMV sys.dm_db_index_physical_stats offers lots of options.

For more details visit - MSDN

Have a nice day.

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon