I am trying to analyze existing indexes on few tables. I think I can do this by using system views like
sys.db_dm_index_usagestats, physicalstats and operationalstats.
I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etc
I am wondering if ,Apart these views, there are some other effective measures for the same?
For accessing these views, one needs to have VIEW DATABASE STATE permission. As of now, I don't have it.
However,If this is the only way to access information then,