A lot of work has gone into this release but many of the changes won’t be immediately obvious as we’ve;

• Changed and standardized every button.
• Relaxed the server limits for Pro versions.
• Improved the handling of licensing issues.

A good example of the changes can been seen in the splash screen. Not huge changes but they’ve been made everywhere. Another example is the comparison configuration screen.

• 

• 

• 

• 

Improvements to Advise

• Added partial support for column store indexes.
• Ignore fragmented indexes now based on pages rather than rows. Defaults to Microsoft recommended value of 1,000 pages.

New Checks

• Database owner does not exist.
• Auto update statistics is disabled.
• Data files larger than 10GB with more than 90% free.

Improved Checks

• Cost threshold for parallelism alerts if set to < 15, but suggests setting it to 30.

New Scripts

• If page verify is NONE or TORN_PAGE, suggest setting to CHECKSUM.
• If auto shrink is enabled, suggest setting to disabled.
• If auto create statistics is disabled, suggest setting to enabled.
• If auto update statistics is disabled, suggest setting to enabled.
• If auto close is enabled, suggest setting to disabled.
• If the compatibility level isn’t the latest, suggest setting to the latest but with a warning.

Improved Scripts

• The suggested size for new tempdb data files are now set to the total space / existing files * number of suggested files.