set-aggregation-options-usage-based-optimization-wizard.md

title	Set Aggregation Options (Usage-Based Optimization Wizard) | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	analysis-services
ms.topic	conceptual
f1_keywords	sql12.asvs.storagedesignwizard.setaggregateoptions.f1
ms.assetid	5e5c59f3-5a2d-44de-b1ba-2c56b76d3c8d
author	minewiskan
ms.author	owend
manager	craigg

Set Aggregation Options (Usage-Based Optimization Wizard)

Use the Set Aggregation Options page to start the aggregation design process, and specify storage or performance limits for the aggregations generated by the Usage-Based Optimization Wizard.

Options

Estimated storage reaches
Limit the aggregation design by indicating the maximum number of megabytes (MB) or gigabytes (GB) that can be used to generate the aggregations.

Performance gain reaches
Limit the aggregation design by indicating the maximum percentage of estimated performance gain that the aggregation design can provide. For best results, use the default setting of 100% for the performance gain value, unless disk space or processing time constraints prevent this.

I click Stop
Limit the aggregation design by clicking Stop during the design process.

Start
Start the aggregation design process.

Stop
End the aggregation design process.

Reset
Reset all the aggregation options on this page to their default values.

See Also

Usage-Based Optimization Wizard F1 Help
Analysis Services Wizards (Multidimensional Data)