General downloads
Index Usage Stats for SQL Server 2005
- Author
- IJeb Reitsma
- Category
- General downloads
- Date
- 29/01/2008
- Size
- 217,45 KB
- Downloads
-
1555
Detailed statistics
- Downloads today 0
- 30 day downloads 5
- Total downloads 1555
- Overall download rank #974 / 2084
- Today page views 0
- 30 days page views 4
- Total views 3751
- Rating
Detailed statistics- x 3 75,00%
- x 0 0%
- x 0 0%
- x 0 0%
- x 1 25,00%
- Popularity
- Downloaded 3 times in the last two weeks
This tool saves information about index usage from a SQL Server 2005 dynamic management view in a NAV table. Snapshots are taken from the dmv sys.dm_db_index_usage_stats in a table created by Dynamics NAV. The information can be analyzed in a NAV form.
This information can be used to decide which indexes can be removed.
