Reducing the impact of Aireforge Studio

Advisor runs live queries against the instance you connect it to, so a broad run has a real cost on a busy server. The options screen (see Performing an Analysis) is how you keep that cost down.

• Turn Tables off if you don't need table- or index-level findings. This is where the expensive per-table and per-index work happens: every table and index check, including the whole of Index Optimisation, only runs when Tables is on.
• Limit to chosen databases, once Databases is on, rather than checking the whole instance.
• Limit to chosen tables, once Tables is on, rather than every table in the databases you've selected.
• Run fewer categories. All excludes housekeeping checks by default; running a single Quick Option, or ticking only the categories you need on the options screen, narrows it further.
• Choose a quiet period. Advisor queries the live server rather than cached data, so running it outside busy hours keeps that load off the server when it matters most.

Advisor is built to help with tuning and administration, not to make changes for you. Verify and test each recommendation before applying it.