Home > IT Answers > Database > Analyzing Existing Indexes
Sqloholic
25 pts.
 Analyzing Existing Indexes
Indexes, SQL Server database, SQL Server tables
Hello, 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, Thanks

Software/Hardware used:
ASKED: October 8, 2008  9:02 PM
UPDATED: October 9, 2008  5:45 AM
RELATED QUESTIONS
Answer Wiki:
Those DMVs would be the correct method to view that information. Any of the legacy methods will not show you that information without having the same rights as needed to view these DMVs.
Last Wiki Answer Submitted:  October 9, 2008  1:55 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.