So, let’s download it and fire it up.
Shortly after starting the tool, it has analyzed all the databases on that server to which I have access, and returns the results:
As you can see, there are two options for action – “Rebuild” or “Reorganize”. Click on those problems that you would like to fix, and hit the “Fix Indexes” button. This gives you the option to run the recommended actions immediately, or will give you the SQL script so you can run it as & when you want. If you click “Fix Now”, it’ll take you to the results grid where you can see what’s going on.
And that’s it – nice and easy.
As it stands, there are no options to change behaviour (eg by setting up your own thresholds, or just selecting one database to scan). As such, this feels either like an early Beta, or a tool that is aimed more at the “accidental” or new DBA.
The thing that I find confusing is also the “Index fragmentation %” – I would (personally) have assumed that a higher number is indicative of a more fragmented index, but apparently this tool thinks otherwise. Checking the TechNet documentation linked above indicates that MS seems to be on my side…
There are a few other behavioural hiccups that need addressing, and I’ve sent a little list to send back to Red Gate. You can help too – download the free beta, play with it, and use the “Give feedback” button to, erm, give feedback via email.
And now to see if it’ll play nicely with SQL Server 2000… I may be some time…Game over rather quickly. Heigh ho.