---
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](usage-based-optimization-wizard-f1-help.md)   
 [Analysis Services Wizards (Multidimensional Data)](analysis-services-wizards-multidimensional-data.md)