Dynamics AX in the Field

Microsoft Dynamics AX from the Premier Field Engineering team at Microsoft.

Performance Analyzer 1.10 for Microsoft Dynamics

Performance Analyzer 1.10 for Microsoft Dynamics

  • Comments 4

We would like to announce the release of Performance Analyzer 1.10 for Microsoft Dynamics.  This new and exciting release has a long list of new features:

Peformance Analyzer 1.10  NOTE: SQL Server 2008 and above only for this version.

  • ·         An hourly capture of data that shows your transaction volume per table per hour
  • ·         Auto configures the SQL jobs to the largest Dynamics database in the instance
  • ·         Major performance enhancements of the data collection
  • ·         The public version of our Database compression analysis tools
  • ·         Support for capturing against multiple databases simultaneously
  • ·         Support for new DMV’s added to SQL 2012 and SQL 2008 R2 SP1
  • ·         Sample database maintenance scripts (superfast scripts)
  • ·         SMALLER database!!  We’ve shrunk the storage requirements of the DynamicsPerf database
  • ·         Many internal reliability additions to the codebase

 

Please stay tuned to this blog for video blogs on this new and exciting release of Performance Analyzer for Microsoft Dynamics from your Dynamics Premier Field Engineering team.

Come visit us at Microsoft Convergence 2012 March 18-21 in Houston, TX.  We look forward to meeting you there.  Come see the session on Performance Analyzer for Microsoft Dynamics presented by Rod Hansen.  He has a special bonus feature for all of you in attendance.

 

  • So the link doesn't seem to work (for me at least) to download the new version.  Will we have to re-create the DynamicsPerf database/jobs etc with this new version or is it just new scripts for analyzing?

  • If you have an older version of the DynamicsPerf databsase, the scripts will drop and recreate all tables and SQL jobs.  So if you have any history that you would like to keep, please backup the database.  

  • There seems to be a problem with the script for creating the objects in the DynamicsPerf database, 2-Create_AX_Objects.sql.

    Error message: Msg 207, Level 16, State 1, Procedure AX_INDEX_DETAIL_CURR_VW, Line 14

    Invalid column name 'TABLE_ID'.

    In fact the view AX_INDEX_DETAIL_CURR_VW cannot be created. The column APPLICATION_LAYER is based on a column TABLE_ID in the base tables. But no such column exists in the tables STATS_COLLECTION_SUMMARY and AX_INDEX_DETAIL.

  • The fix has been uploaded and the upload date is 1/12/2012 on the download site. Please download the update.

    Thank you very much for the report !!

Page 1 of 1 (4 items)