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

New Advise module and Aireforge Studio v1.0.7

What’s new at Aireforge?

We’re pleased to announce that Aireforge Studio is now officially live and supported. Version 1.0.7 ships with hundreds of improvements with a new UI, simpler comparisons with advanced options, 2017 support and our new tuning / best practices module; Advise.
Depending on your version, the application should prompt to update after starting. If not, please download the latest version using the link below.

Introducing Advise

Download images

The new Advise module within Aireforge Studio analyses instances, databases, tables and indexes, before providing recommendations. The growing list of checks vary from best practices and naming convention violations to orphaned users and missing, duplicate or overlapping indexes.

Read more…

Compare v1 & Custom Comparisons

Download images

The Compare module within Aireforge Studio performs a growing list of comparisons, which can be restricted if certain values are known to differ, such as core count or edition (e.g. Enterprise vs Developer).

Common use cases for Aireforge Studio Compare are checking production databases against staging and / or staging against test, auditing the SQL Server estate, sharing configurations with colleagues / support teams.

Read more…