--- title: "Usage-Based Optimization Wizard F1 Help | 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.usagebasedoptimizationwizard.f1" helpviewer_keywords: - "Usage-Based Optimization Wizard" ms.assetid: e5f5a938-ae7c-4f4e-9416-a7f94ac82763 author: minewiskan ms.author: owend manager: craigg --- # Usage-Based Optimization Wizard F1 Help The Usage-Based Optimization Wizard is similar in output to the Aggregation Design Wizard, and is used to design aggregations for a partition. However, the Usage-Based Optimization Wizard designs aggregations based on the specific usage patterns of queries recorded in the query log of an [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] instance. Aggregations provide performance improvements by allowing [!INCLUDE[msCoName](../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] to retrieve pre-calculated totals directly from cube storage instead of having to recalculate data from an underlying data source for each query. To open the Usage-Based Optimization Wizard from within [!INCLUDE[ssBIDevStudioFull](../includes/ssbidevstudiofull-md.md)], open the cube designer for an [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] project, and then click the **Aggregations** tab. Click the **Usage Based Optimization** button in the toolbar. To open the Usage-Based Optimization Wizard from within [!INCLUDE[ssManStudioFull](../includes/ssmanstudiofull-md.md)], connect to an [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] database and then open the **Cubes** folder. Select a cube and then open the **Measure Groups** folder and expand the measure group that you want to modify. Right-click the **Partitions** folder and then select **Usage Based Optimization**. To design these aggregations, you can use the Aggregation Design Wizard. This wizard guides you through the following steps: - Selecting standard or custom settings for the storage and caching options of a partition, measure group, or cube. - Providing estimated or actual counts for objects referenced by the partition, measure group, or cube. - Specifying aggregation options and limits to optimize the storage and query performance delivered by designed aggregations. - Saving and optionally processing the partition, measure group, or cube to generate the defined aggregations. [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] provides the Aggregation Design Wizard to design aggregations based on statistical analysis of the structure of the partition to deliver an aggregation design that can be limited by storage size or estimated performance gain. You can use the Aggregation Design Wizard to improve the overall performance of a partition, but the aggregation design is not targeted to the specific needs of your business users. The Usage-Based Optimization Wizard can provide an aggregation design targeted to these specific needs, but the wizard can do so only if the query log for the [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] instance contains enough information to construct such queries. Typically, both wizards are used together to improve performance both upon deployment and over time. The Aggregation Design Wizard should be used first, when the partition (or the cube or measure group containing the partition) is initially deployed, to provide an overall performance benefit. After a period of time during which you have recorded the queries of business users for the partition in the query log, you can then use the Usage-Based Optimization Wizard to further focus the aggregation design to better serve the performance and query requirements of your business users. > [!NOTE] > For information about configuring the query log, see [Configuring the Analysis Services Query Log](instances/log-operations-in-analysis-services.md?view=sql-server-2014#bkmk_querylog). ## In This Section - [Select Partitions to Modify (Usage-Based Optimization Wizard)](select-partitions-to-modify-usage-based-optimization-wizard.md) - [Specify Query Criteria (Usage-Based Optimization Wizard)](specify-query-criteria-usage-based-optimization-wizard.md) - [Review the Queries that will be Optimized (Usage-Based Optimization Wizard)](review-the-queries-that-will-be-optimized-usage-based-optimization-wizard.md) - [Review Aggregation Usage (Usage-Based Optimiation Wizard)](review-aggregation-usage-usage-based-optimiation-wizard.md) - [Specify Object Counts (Usage-Based Optimization Wizard)](specify-object-counts-usage-based-optimization-wizard.md) - [Set Aggregation Options (Usage-Based Optimization Wizard)](set-aggregation-options-usage-based-optimization-wizard.md) - [Completing the Wizard (Usage-Based Optimization Wizard)](completing-the-wizard-usage-based-optimization-wizard.md) ## See Also [Aggregations and Aggregation Designs](multidimensional-models-olap-logical-cube-objects/aggregations-and-aggregation-designs.md) [Cubes in Multidimensional Models](multidimensional-models/cubes-in-multidimensional-models.md) [Aggregation Design Wizard F1 Help](aggregation-design-wizard-f1-help.md) [Analysis Services Wizards (Multidimensional Data)](analysis-services-wizards-multidimensional-data.md)