Database Engine Tuning Advisor
The Database Engine Tuning Advisor can:
- · Recommend the best mix of indexes for databases by using the query optimizer to analyze queries in a workload.
- · Recommend aligned or non-aligned partitions for databases referenced in a workload.
- · Recommend indexed views for databases referenced in a workload.
- · Analyze the effects of the proposed changes, including index usage, query distribution among tables, and query performance in the workload.
- · Recommend ways to tune the database for a small set of problem queries.
- · Allow you to customize the recommendation by specifying advanced options such as disk space constraints.
- · Provide reports that summarize the effects of implementing the recommendations for a given workload.
- · Consider alternatives in which you supply possible design choices in the form of hypothetical configurations for Database Engine Tuning Advisor to evaluate.
Above Database Engine Tuning Advisor’s information taken from the MSDN
No comments:
Post a Comment