Aireforge Studio 1.1.9

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.

This slideshow requires JavaScript.

 

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.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s