Dynamicsperf 2.20

Version 2.20
Added a view for the Database Scoped data for SQL 2016+
Fixed some of the Always On views for performance
Added a MAX_TIME column to the AX BATCH HISTORY table
Updated the AX BATCH HISTORY views for the new MAX_TIME column
Updated QUERY ALERTS process so you can enter multiple ranges in QUERY_ALERTS_CONFIG table
Added indexes to QUERY ALERTS table
Added new table AX_BATCH_ALERTS_CONFIG, define parms for out of ordinary run times
Added new table AX_BATCH_ALERTS, batch jobs that took abnormal amount of time based on user defined settings
Added new sproc DYNPERF_PROCESS_AX_BATCH_ALERTS to track batch jobs running abnormally
Added new table AX_NUMBERSEQUENCE_HISTORY, for daily and monthly consumption rates
Added new sproc DYNPERF_UPDATE_AXNUMSEQ_HISTORY to aggregate number sequences into daily and monlthly totals
Added new table AX_NUMSEQ_ALERTS to add rules for alerting on number sequences, high usage or running out of numbers
Added new sproc DYNPERF_PROCESS_AXNUMSEQ_ALERTS to process AX Number Sequence Alerts based on user defined settings
Added new table SSRS_ALERTS_CONFIG for configure SSRS reports running abnormally
Added new table SSRS_ALERTS for reports running abnormally
Added new sproc DYNPERF_PROCESS_SSRS_ALERTS to process SSRS Alerts based on user defined settings
Added support for local as the SERVER_NAME so that DynamicsPerf can be installed locally on SQL Always On
and run regardless of which node is hosting the database
ADD NEW SPROCS TO SCHEDULES AND PURGE SCRIPTS (Alerts are 14 days, history is based upon DATABASES_2_COLLECT setting)
Adjusted ax_number_sequences data retention to 2 days since we now have history
Added defaults for the new alerts table to script 4-ConfigureDBs to Collect
Adjusted the retention period for Month to 6 months from 13 and Days from 60 to 31
Added script to install to install the DynamicsPerf SQL Jobs on secondary nodes for Always On installations
Added default value to max_avg_time_ms in the upgrade script since we added the new column
Fixed an issue collecting Database File information for offline databases
New sample queries for the new data

DynamicsPerf 2.10

Version 2.1
Added support for Dynamics 365 Local Business Data (on prem)
Added collectors for Dynamics 365/AX BatchJobHistory data
Added historical data aggregation for BatchJobHistory data into Daily and Monthly totals
Added SQL Server Always On configuration data to the database
Fixed missing data when Dynperf Server and Server collecting data from are in different time zones
Added new views and sample queries for each of the above new data collection sets

DynamicsPerf 2.0

Nov. 2017 release

New and improved SSRS reports
Improves data collection to keep the database size much smaller.
Adds improvements to data collection to improve overall performance of data collection
Adds database compression scripts for Microsoft Dynamics AX