Brent Ozar tries out a new feature of SQL Server Management Studio:
The maximum tuning time defaults to 300 seconds, but I tacked on a couple zeroes because my slow query already took ~20 seconds to run on its own, and I wanted to give the wizard time to wave his little wand around. The tool actually runs your query repeatedly with different hints, so if you have a 5-minute query, you’ll need to give the tool more time.
Click Start, and it begins running your query with different hints. A couple minutes later, I got:
Brent’s review is quite positive, in a “This is way better than the alternative of doing nothing” sense.