- Download the attached script
- Open Enterprise Manager / DBA Studio
- Login to the database that you are trying to analyze
- Open a new query window
![](http://www.opssys.com/instantkb/Attachments/7db494d9-84e2-403d-88d5-cd15.jpg)
- Open Script in Notepad
![](http://www.opssys.com/instantkb/Attachments/7cb0a2e9-8319-4827-a7aa-305f.jpg)
- Select all text and Copy it.
![](http://www.opssys.com/instantkb/Attachments/a70c6811-c6a4-408e-8b3a-9b07.jpg)
- Paste the text into your query Window
![](http://www.opssys.com/instantkb/Attachments/2f51629d-ed5c-4e54-9085-d157.jpg)
- Click EXECUTE
![](http://www.opssys.com/instantkb/Attachments/6fa503f2-9a27-4bea-9c1d-c411.jpg)
- You should get a result back looking like this :
![](http://www.opssys.com/instantkb/Attachments/9173b45c-a4e0-41aa-bfc6-3228.jpg)
See Also: Recommendations for Index Maintenance in Microsoft SQL Server
|