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

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

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

DynamicsPerf 2.0 Deployment Guide

INTRODUCTION The tool DynamicsPerf (Performance Analyzer for Dynamics) is used by Microsoft Dynamics Support team, Premier Field Engineers and Product Group team members to diagnose performance issues with Dynamics products such as Dynamics AX and Dynamics CRM. IMPORTANT: The purpose of the Performance Analyzer is to be used on a continual basis so it is…

22

DynamicsPerf 2.0 Installation for Dynamics AX

INTRODUCTION Please be sure to install the core components of Performance Analyzer for Microsoft Dynamics before completing this guide. Dynamicsperf-2-0-deployment-guide The Performance Analyzer is delivered as a SQL Server solution and consists of a number of collectors as SQL jobs, X++ classes, VB scripts and performance counters. It also includes a set of sample SQL scripts…

10

DynamicsPerf Deep Dive – The Vision

  Before I dive into all of the things you can do with DynamicsPerf, I think it’s important that I describe its history as this will tell you a lot about the vision for the toolset. DynamicsPerf was born during the development of SQL Server 2005 which gave us Dynamic Management Views (DMVs).  Mark Prazak…

2

DynamicsPerf 1.20 RTM is HERE !!

  I would like to announce that the RTM build of DynamicsPerf 1.20 has been posted to http://dynamicsperf.codeplex.com.  There is an upgrade script for both 1.20 RC0 and for those running on 1.16.  A big thank you to everyone that gave feedback on this version!! I will be authoring a series of blog articles called…

5