DynamicsPerf 2.0 Nov. 2017 Patch is Released !!

With the move over to Github: https://github.com/PFEDynamics/DynamicsPerf , we have also posted a new patch for DynamicsPerf 2.0.   Highlights: New SSRS reports – Updated reports based on the INDEX_HISTORY table in DynamicsPerf New and improved sample queries .. .. Improved collection to better limit the SIZE of DynamicsPerf  !!   We have been testing…


New HOME for DynamicsPerf !!!!

With codeplex shutting down, we have moved DynamicsPerf over to Github.   You can find the download at:  https://github.com/PFEDynamics/DynamicsPerf   Rod “Hotrod” Hansen


DynamicsPerf 2.0 Release Candidate 0 is HERE !!

Release Candidate 0 is finally complete.  You can find the download here: DynamicsPerf 2.0. A big THANK YOU to my early testers of RC0!! They were able to help me find a last minute issue which was the cause of the delay between when I posted the What’s New in DynamicsPerf 2.0 Release Candidate 0…

4

What’s New in DynamicsPerf 2.0 Release Candidate 0

First, I want to say “Thank You” to the community.  All of the feedback has been greatly appreciated.   Let’s start with SSRS data collection.   This is now working as designed.  There were some schema changes needed to get this working as necessary so the upgrade script will truncate the SSRS_HISTORY table and the…

11

What’s New in Beta 5

A big THANKS to the community that has been helping test DynamicsPerf 2.0 !! Beta 5 has been posted here: DynamicsPerf 2.0 Beta 5 For anyone who has an older beta installed, it is highly recommended to upgrade to Beta 5.  The biggest issue that has been corrected in Beta 5 is the purge script. …

13

DynamicsPerf 2.0 QUERY ALERTS

In the upcoming Beta 3 of DynamicsPerf 2.0, we have implemented a new feature called QUERY ALERTS.  The inspiration for the design has come from all of you.  One of the big challenges that we all face with performance is that sudden slowdown of the system.  In general, this happens for 2 major reasons, database…

1

Top 10 actions to troubleshoot performance of MRP

I wanted to write this blog post after a couple of Dynamics AX Performance Review where the Targeted scenario was execution of the MRP Batch. Every situation is different but there are similarities as well, especially when it comes to troubleshooting and patterns for improving performance. The objective of this article is to describe top…


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 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…