Using SQL Server Database Engine Tuning Advisor
SQL Server Database Engine Tuning Advisor allows developers to analyze and improve database queries. Database Engine Tuning Advisor examines query usage and recommends how it can be improved. Though most of the time the results of this tool are accurate, before making any database changes it is recommended to confirm them manually or by using another technique.
In this recipe, we will use Database Engine Tuning Advisor to analyze the query captured by Trace Parser from the previous recipe.
How to do it...
Carry out the following steps in order to complete this recipe:
- Open SQL Server Management Studio and connect to the server where your Dynamics AX database resides.
- Select the Dynamics AX database, ...
Get Microsoft Dynamics AX 2012 Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
