Davide
Mauri has
published a number of SQL Server 2005 scripts he uses as part of his DBA
toolkit to analyse indexes including their usage and health. They’re a great
short cut to building your own after wading through BOL.
So far there are four UDFs he’s published that show the indexes on a table,
the size of indexes, index fragmentation, and usage.
Download the scripts
from here.
In the next few weeks I plan to publish my set of dba scripts for SQL Server
2000 and 2005. Subscribe to
my rss feed to make sure you get updates.