You can download the latest release of Performance Analyzer 1.16 for Microsoft Dynamics at the following: http://dynamicsperf.codeplex.com.
This release officially supports SQL Server 2012 and all currently released Dynamics Products. There have been several performance improvements incorporated into this version especially around analyzing QUERY data. For the operational staff, we have enhanced the QUICK ACTIVITY MONITOR query to display all currently executing SQL statements, all current blocks, and open database cursors that have run in the last minute. Also included in this release, are the sample SSRS reports, which you will find located in the REPORTS folder when you unzip the project.
We have made a change in how we purge data from the database in this release. We will keep the last data collection per SQL Server restart regardless of @PURGE_DAYS. This will allow for long term analysis of Query and Index usage over time. You will be able to compare Query data before and after a patch to your SQL Server as an example. You will be able to determine if that index has ever been used vs. today where you can only see if it has been used since your last SQL restart.
There are many exciting things that we will be adding in the next version of Performance Analyzer that I will be sharing with you over the next several months. So, please stay tuned to the Blog for new and exciting features coming to your favorite performance tool for your Microsoft Dynamics product.
I will be presenting Performance Analyzer at Convergence this year. I’ll be presenting on Wed. Mar. 20, 2013 at 5pm and Thur. Mar. 21, 2013 at 4pm. Please stop by and say hello if you are attending Convergence 2013. The session is named “Maximizing SQL Performance for Microsoft Dynamics”.
Rod ‘Hotrod’ Hansen