Book Image

Microsoft Dynamics AX 2012 Development Cookbook

By : Mindaugas Pocius
Book Image

Microsoft Dynamics AX 2012 Development Cookbook

By: Mindaugas Pocius

Overview of this book

Microsoft Dynamics AX is a comprehensive Enterprise Resource Planning (ERP) solution for mid-size and large organizations. Dynamics AX implementations are used worldwide by thousands of customers. With the new version - Dynamics AX 2012 - the system is due to expand even more rapidly. Every new implementation requires some level of customization, and all organizations want this to be done to the highest standards using proven approaches. Written by one of the leading experts in Microsoft Dynamics AX, 'Microsoft Dynamics AX 2012 Development Cookbook' is packed with over 80 task-based and immediately reusable recipes that will help you manage your company's or customer's ERP information and operations efficiently, and solve your business process problems in an effective and quick way. This book focuses on commonly used custom modifications in major Dynamics AX modules. The recipes in this book cover various areas of Dynamics AX to help developers not only learn about programming, but also about the functional side of Dynamics AX. The practical recipes will also allow you to look at the development from the perspective of business processes. You will learn to enhance your user interface using various Dynamics AX UI elements and managing your data and functions will become easier.
Table of Contents (15 chapters)
Microsoft Dynamics AX 2012 Development Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

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:

  1. 1. Open SQL Server Management Studio and connect to the server where your Dynamics AX database resides.

  2. 2. Select the Dynamics AX database, create a new query, and copy the SQL statement from Trace Parser from the previous recipe. Execute the query to ensure it is error free:

  3. 3. Right-click anywhere in the query window, and from the context menu select Analyze Query in Database...