DynamicsPerf 2.0 Comparing AX schema

With DynamicsPerf 2.0 , we made schema changes to better support multiple databases and environments.  This change includes AOTEXPORT class that provides table and index schema from Dynamics AX into the DynamicsPerf database. The new AOTEXPORT class now writes data directly to DynamicsPerf.  What this allows you to do that you really couldn’t do before…


DynamicsPerf 2.0 Feedback

We would love to hear from everyone that installs DynamicsPerf 2.0.  Please leave your feedback in the comments of this post.  Please add the following: Dynamics Product/Version SQL Version How has DynamicsPerf helped you? What would you like to see added next? Please post any defects on the ISSUES page of the DynamicsPerf on Codeplex…

22

DynamicsPerf 2.0 IS HERE !!

I have opened the downloads for DynamicsPerf 2.0 Beta 1 today Jan. 6, 2016.  You can download it from here: DynamicsPerf 2.0 for SQL2008R2 and Above. The deployment guide for installation can be found here: DynamicsPerf 2.0 Deployment Guide.aspx Please post any issues you may find on the ISSUES tab of the download site.  I…

7

Setting up Windows Performance Monitor Templates

To log valuable information about your database server such as disk, processor, memory and network, it is important to configure and schedule the performance counter logging. In the following steps, you will configure the database server for performance counter logging. This information will be logged to performance counter log files. First we can setup the…


DynamicsPerf 2.0 Historical Tables and Baselines

Another one of the new features in version 2.0 is the addition of HISTORICAL TABLES: QUERY_HISTORY INDEX_HISTORY We collect query data every 5 minutes by default and index data every hour on the hour. With this increase in collection of detailed data, it was pretty apparent that the DynamicsPerf database would quickly grow to large.We…


DynamicsPerf 2.0 Scheduling Engine

  One of the new features of DynamicsPerf 2.0 is the way tasks are now run using a scheduling engine inside of DynamicsPerf. There were 2 goals for this new design.  The first being able to deliver customized data collection for different environments.  A good example of this would be for collection at a retail…

6