Intelligent Data Management in Microsoft Dynamics AX

1. Intelligent Data Management in Microsoft Dynamics AX Tao Wang Principal Development Manager Dynamics AX performance Microsoft Corporation

2. Agenda • Overview • Pre Requisites and Deployment • Core Features • Intelligent Data Management • Purging • Scheduling • Alerting/Thresholds • Performance Dashboard • Archiving • Restore • Templates • Archive by Fiscal Period (Continued TAP – not in RTM) • Planning for Implementation • Is your Codebase ready?

3. Intelligent Data Management • Monitors AX DB health on the productions system • Suggests actions to optimize runtime DB performance • Archives historical data • Purges obsolete data • Helps understand AX DB Schema

4. Release Details • Current State: In TAP (Few Days from RTM) • Availability To: • TAP Customers • Non Production Bits – CustomerSource and PartnerSource • Planned RTM Date: Oct 2010 • Versions Supported • 3.0/4.0/2009 • Database Support • SQL 2005 SP2 and SQL 2008 ONLY

5. Pre- Requisite

6. Post-installation Steps

7. Intelligent Data Management Framework: V1 Architecture

8. Configurations – single box Client IDM Console AOS BC .NET IDM Management Database AX Database Production AX Database Test

9. Configurations: Multiple Boxes Box 2 Client IDM Console AOS BC .NET Box 1 IDM Database AX Database Production AX Database Test

10. Configurations: More Boxes Box 4 Client IDM Console AOS BC .NET Box 1 Box 3 Box 2 IDM Database AX Database Production AX Database Test

11. Intelligent Data Management Framework: Core Features Tao Wang Principal Dev Manager Microsoft demo

12. Core Features • Performance Dashboard • Scheduling • Purging • Alerting/Thresholds • Archiving • Restore • Templates • Archive by Fiscal Period

13. Intelligent Data Management Framework: Purge Data Flow SalesParmTable PURGE_360 SalesParmLine SalesParmSubTable SalesParmUpdate PURGE_361 PURGE_1293 PURGE_1428 SalesParmSubLine PURGE_1549

14. AX IDMF Archiving Service Explained AX Archive Service Active Inactive Move Inactive Data from Active to Archive Active Inactive Empty Database Reference Reference Replicate Reference Data Archive Database Active Database

15. Archive: Fiscal Year Sliding Scale for Your ONLINE Database FY 2008 2008* 2007 2004 2005 2006 FY 2009 2009* 2008 2007 FY 2010 2010* 2009 2008

16. Planning for Implementations

17. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

18. Backup screen images in case of network breakdown