Maintenance Plan Index Rebuild Gotcha

If you’re anything like me, you probably have a tendency to read what you think is on the page instead of what is actually there. Here’s a little gotcha that I discovered today when setting up the Rebuild Index task in a maintenance plan:

Click to view full size


As you can see, the percentage they are asking for is the amount of free space to leave on the index pages, and NOT the fillfactor for the index pages. Had I read this screen more carefully yesterday, I would have saved myself and my colleagues much pain and suffering today (a database with 90% free space in the indexes doesn’t perform well AT ALL…lol). 🙁

Leave a Reply