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,
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!