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,
October 8, 2008 9:02 PM
October 9, 2008 5:45 AM