Improvements for Performance and Error Troubleshooting in Dynamics Operations

Improvements for Performance and Error Troubleshooting in Dynamics Operations

I absolutely love some of the new troubleshooting tools in Dynamics Operations. In what was superior architecture, Microsoft invested heavily in addressing many of the performance and strange errors seen in previous versions and making it easier for those of us in some sort of support role to get things going. I want to talk about two new performance features. First, you’ve got to try out the new version of the Trace Parser. Second, see the performance counters below for some serious fire power. Third, there is a new version of DynaPerf in town but I didn’t have time to talk about it tonight.

First, notice the new version of the trace parser. There are still the old things that we came to love like being able to see the SQL with parameters and call stacks.

But then there are the new things also like this initial look and feel. Notice the new hooked up Trace Parser. We have a beginning screen with data that can be fully filtered. No more drama with trying to correlate event logs with errors. The information is right there.

Plus, we can take notes on our instances. I’d say that this is a huge improvement.

One area that has really had some improvements for Dynamics Operations are the performance counters.

CategoryName CounterName Counter Description
Dynamics Retail – CDX – Apply Offline Data AverageLatencyInMs AverageLatencyInMs
Dynamics Retail – CDX – Apply Offline Data AverageLatencyInMsBase AverageLatencyInMsBase
Dynamics Retail – CDX – Apply Offline Data BytesReceived BytesReceived
Dynamics Retail – CDX – Apply Offline Data BytesReceivedAverage BytesReceivedAverage
Dynamics Retail – CDX – Apply Offline Data BytesReceivedAverageBase BytesReceivedAverageBase
Dynamics Retail – CDX – Apply Offline Data BytesSent BytesSent
Dynamics Retail – CDX – Apply Offline Data BytesSentAverage BytesSentAverage
Dynamics Retail – CDX – Apply Offline Data BytesSentAverageBase BytesSentAverageBase
Dynamics Retail – CDX – Apply Offline Data FailedCalls FailedCalls
Dynamics Retail – CDX – Apply Offline Data FailedCallsPerSecond FailedCallsPerSecond
Dynamics Retail – CDX – Apply Offline Data FailedCallsRatio FailedCallsRatio
Dynamics Retail – CDX – Apply Offline Data FailedCallsRatioBase FailedCallsRatioBase
Dynamics Retail – CDX – Apply Offline Data LastLatencyInMs LastLatencyInMs
Dynamics Retail – CDX – Apply Offline Data SucceededCalls SucceededCalls
Dynamics Retail – CDX – Apply Offline Data SucceededCallsPerSecond SucceededCallsPerSecond
Dynamics Retail – CDX – Apply Offline Data SucceededCallsRatio SucceededCallsRatio
Dynamics Retail – CDX – Apply Offline Data SucceededCallsRatioBase SucceededCallsRatioBase
Dynamics Retail – CDX – Apply Offline Data TotalCalls TotalCalls
Dynamics Retail – CDX – Apply Offline Data TotalCallsPerSecond TotalCallsPerSecond
Dynamics Retail – CDX – Download jobs AverageLatencyInMs AverageLatencyInMs
Dynamics Retail – CDX – Download jobs AverageLatencyInMsBase AverageLatencyInMsBase
Dynamics Retail – CDX – Download jobs BytesReceived BytesReceived
Dynamics Retail – CDX – Download jobs BytesReceivedAverage BytesReceivedAverage
Dynamics Retail – CDX – Download jobs BytesReceivedAverageBase BytesReceivedAverageBase
Dynamics Retail – CDX – Download jobs BytesSent BytesSent
Dynamics Retail – CDX – Download jobs BytesSentAverage BytesSentAverage
Dynamics Retail – CDX – Download jobs BytesSentAverageBase BytesSentAverageBase
Dynamics Retail – CDX – Download jobs FailedCalls FailedCalls
Dynamics Retail – CDX – Download jobs FailedCallsPerSecond FailedCallsPerSecond
Dynamics Retail – CDX – Download jobs FailedCallsRatio FailedCallsRatio
Dynamics Retail – CDX – Download jobs FailedCallsRatioBase FailedCallsRatioBase
Dynamics Retail – CDX – Download jobs LastLatencyInMs LastLatencyInMs
Dynamics Retail – CDX – Download jobs SucceededCalls SucceededCalls
Dynamics Retail – CDX – Download jobs SucceededCallsPerSecond SucceededCallsPerSecond
Dynamics Retail – CDX – Download jobs SucceededCallsRatio SucceededCallsRatio
Dynamics Retail – CDX – Download jobs SucceededCallsRatioBase SucceededCallsRatioBase
Dynamics Retail – CDX – Download jobs TotalCalls TotalCalls
Dynamics Retail – CDX – Download jobs TotalCallsPerSecond TotalCallsPerSecond
Dynamics Retail – CDX – Download Offline Data AverageLatencyInMs AverageLatencyInMs
Dynamics Retail – CDX – Download Offline Data AverageLatencyInMsBase AverageLatencyInMsBase
Dynamics Retail – CDX – Download Offline Data BytesReceived BytesReceived
Dynamics Retail – CDX – Download Offline Data BytesReceivedAverage BytesReceivedAverage
Dynamics Retail – CDX – Download Offline Data BytesReceivedAverageBase BytesReceivedAverageBase
Dynamics Retail – CDX – Download Offline Data BytesSent BytesSent
Dynamics Retail – CDX – Download Offline Data BytesSentAverage BytesSentAverage
Dynamics Retail – CDX – Download Offline Data BytesSentAverageBase BytesSentAverageBase
Dynamics Retail – CDX – Download Offline Data FailedCalls FailedCalls
Dynamics Retail – CDX – Download Offline Data FailedCallsPerSecond FailedCallsPerSecond
Dynamics Retail – CDX – Download Offline Data FailedCallsRatio FailedCallsRatio
Dynamics Retail – CDX – Download Offline Data FailedCallsRatioBase FailedCallsRatioBase
Dynamics Retail – CDX – Download Offline Data LastLatencyInMs LastLatencyInMs
Dynamics Retail – CDX – Download Offline Data SucceededCalls SucceededCalls
Dynamics Retail – CDX – Download Offline Data SucceededCallsPerSecond SucceededCallsPerSecond
Dynamics Retail – CDX – Download Offline Data SucceededCallsRatio SucceededCallsRatio
Dynamics Retail – CDX – Download Offline Data SucceededCallsRatioBase SucceededCallsRatioBase
Dynamics Retail – CDX – Download Offline Data TotalCalls TotalCalls
Dynamics Retail – CDX – Download Offline Data TotalCallsPerSecond TotalCallsPerSecond
Dynamics Retail – CDX – Upload job AverageLatencyInMs AverageLatencyInMs
Dynamics Retail – CDX – Upload job AverageLatencyInMsBase AverageLatencyInMsBase
Dynamics Retail – CDX – Upload job BytesReceived BytesReceived
Dynamics Retail – CDX – Upload job BytesReceivedAverage BytesReceivedAverage
Dynamics Retail – CDX – Upload job BytesReceivedAverageBase BytesReceivedAverageBase
Dynamics Retail – CDX – Upload job BytesSent BytesSent
Dynamics Retail – CDX – Upload job BytesSentAverage BytesSentAverage
Dynamics Retail – CDX – Upload job BytesSentAverageBase BytesSentAverageBase
Dynamics Retail – CDX – Upload job FailedCalls FailedCalls
Dynamics Retail – CDX – Upload job FailedCallsPerSecond FailedCallsPerSecond
Dynamics Retail – CDX – Upload job FailedCallsRatio FailedCallsRatio
Dynamics Retail – CDX – Upload job FailedCallsRatioBase FailedCallsRatioBase
Dynamics Retail – CDX – Upload job LastLatencyInMs LastLatencyInMs
Dynamics Retail – CDX – Upload job SucceededCalls SucceededCalls
Dynamics Retail – CDX – Upload job SucceededCallsPerSecond SucceededCallsPerSecond
Dynamics Retail – CDX – Upload job SucceededCallsRatio SucceededCallsRatio
Dynamics Retail – CDX – Upload job SucceededCallsRatioBase SucceededCallsRatioBase
Dynamics Retail – CDX – Upload job TotalCalls TotalCalls
Dynamics Retail – CDX – Upload job TotalCallsPerSecond TotalCallsPerSecond
Dynamics Retail – Channel DB – Execute Query Boundary AverageLatencyInMs AverageLatencyInMs
Dynamics Retail – Channel DB – Execute Query Boundary AverageLatencyInMsBase AverageLatencyInMsBase
Dynamics Retail – Channel DB – Execute Query Boundary FailedCalls FailedCalls
Dynamics Retail – Channel DB – Execute Query Boundary FailedCallsPerSecond FailedCallsPerSecond
Dynamics Retail – Channel DB – Execute Query Boundary FailedCallsRatio FailedCallsRatio
Dynamics Retail – Channel DB – Execute Query Boundary FailedCallsRatioBase FailedCallsRatioBase
Dynamics Retail – Channel DB – Execute Query Boundary LastLatencyInMs LastLatencyInMs
Dynamics Retail – Channel DB – Execute Query Boundary SucceededCalls SucceededCalls
Dynamics Retail – Channel DB – Execute Query Boundary SucceededCallsPerSecond SucceededCallsPerSecond
Dynamics Retail – Channel DB – Execute Query Boundary SucceededCallsRatio SucceededCallsRatio
Dynamics Retail – Channel DB – Execute Query Boundary SucceededCallsRatioBase SucceededCallsRatioBase
Dynamics Retail – Channel DB – Execute Query Boundary TotalCalls TotalCalls
Dynamics Retail – Channel DB – Execute Query Boundary TotalCallsPerSecond TotalCallsPerSecond
Dynamics Retail – Channel DB – Stored Proc Boundary AverageLatencyInMs AverageLatencyInMs
Dynamics Retail – Channel DB – Stored Proc Boundary AverageLatencyInMsBase AverageLatencyInMsBase
Dynamics Retail – Channel DB – Stored Proc Boundary FailedCalls FailedCalls
Dynamics Retail – Channel DB – Stored Proc Boundary FailedCallsPerSecond FailedCallsPerSecond
Dynamics Retail – Channel DB – Stored Proc Boundary FailedCallsRatio FailedCallsRatio
Dynamics Retail – Channel DB – Stored Proc Boundary FailedCallsRatioBase FailedCallsRatioBase
Dynamics Retail – Channel DB – Stored Proc Boundary LastLatencyInMs LastLatencyInMs
Dynamics Retail – Channel DB – Stored Proc Boundary SucceededCalls SucceededCalls
Dynamics Retail – Channel DB – Stored Proc Boundary SucceededCallsPerSecond SucceededCallsPerSecond
Dynamics Retail – Channel DB – Stored Proc Boundary SucceededCallsRatio SucceededCallsRatio
Dynamics Retail – Channel DB – Stored Proc Boundary SucceededCallsRatioBase SucceededCallsRatioBase
Dynamics Retail – Channel DB – Stored Proc Boundary TotalCalls TotalCalls
Dynamics Retail – Channel DB – Stored Proc Boundary TotalCallsPerSecond TotalCallsPerSecond
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary AverageLatencyInMs AverageLatencyInMs
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary AverageLatencyInMsBase AverageLatencyInMsBase
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary BytesReceived BytesReceived
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary BytesReceivedAverage BytesReceivedAverage
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary BytesReceivedAverageBase BytesReceivedAverageBase
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary BytesSent BytesSent
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary BytesSentAverage BytesSentAverage
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary BytesSentAverageBase BytesSentAverageBase
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary FailedCalls FailedCalls
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary FailedCallsPerSecond FailedCallsPerSecond
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary FailedCallsRatio FailedCallsRatio
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary FailedCallsRatioBase FailedCallsRatioBase
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary LastLatencyInMs LastLatencyInMs
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary ResultsCount ResultsCount
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary ResultsCountAverage ResultsCountAverage
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary ResultsCountAverageBase ResultsCountAverageBase
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary SucceededCalls SucceededCalls
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary SucceededCallsPerSecond SucceededCallsPerSecond
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary SucceededCallsRatio SucceededCallsRatio
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary SucceededCallsRatioBase SucceededCallsRatioBase
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary TotalCalls TotalCalls
Dynamics Retail – Cortana Intelligence – Recommendation Request Boundary TotalCallsPerSecond TotalCallsPerSecond
Dynamics Retail – Realtime Async Service – Client Request Boundary AverageLatencyInMs AverageLatencyInMs
Dynamics Retail – Realtime Async Service – Client Request Boundary AverageLatencyInMsBase AverageLatencyInMsBase
Dynamics Retail – Realtime Async Service – Client Request Boundary BytesReceived BytesReceived
Dynamics Retail – Realtime Async Service – Client Request Boundary BytesReceivedAverage BytesReceivedAverage
Dynamics Retail – Realtime Async Service – Client Request Boundary BytesReceivedAverageBase BytesReceivedAverageBase
Dynamics Retail – Realtime Async Service – Client Request Boundary BytesSent BytesSent
Dynamics Retail – Realtime Async Service – Client Request Boundary BytesSentAverage BytesSentAverage
Dynamics Retail – Realtime Async Service – Client Request Boundary BytesSentAverageBase BytesSentAverageBase
Dynamics Retail – Realtime Async Service – Client Request Boundary FailedCalls FailedCalls
Dynamics Retail – Realtime Async Service – Client Request Boundary FailedCallsPerSecond FailedCallsPerSecond
Dynamics Retail – Realtime Async Service – Client Request Boundary FailedCallsRatio FailedCallsRatio
Dynamics Retail – Realtime Async Service – Client Request Boundary FailedCallsRatioBase FailedCallsRatioBase
Dynamics Retail – Realtime Async Service – Client Request Boundary LastLatencyInMs LastLatencyInMs
Dynamics Retail – Realtime Async Service – Client Request Boundary SucceededCalls SucceededCalls
Dynamics Retail – Realtime Async Service – Client Request Boundary SucceededCallsPerSecond SucceededCallsPerSecond
Dynamics Retail – Realtime Async Service – Client Request Boundary SucceededCallsRatio SucceededCallsRatio
Dynamics Retail – Realtime Async Service – Client Request Boundary SucceededCallsRatioBase SucceededCallsRatioBase
Dynamics Retail – Realtime Async Service – Client Request Boundary TotalCalls TotalCalls
Dynamics Retail – Realtime Async Service – Client Request Boundary TotalCallsPerSecond TotalCallsPerSecond
Dynamics Retail – Realtime Service – Client Request Boundary AverageLatencyInMs AverageLatencyInMs
Dynamics Retail – Realtime Service – Client Request Boundary AverageLatencyInMsBase AverageLatencyInMsBase
Dynamics Retail – Realtime Service – Client Request Boundary BytesReceived BytesReceived
Dynamics Retail – Realtime Service – Client Request Boundary BytesReceivedAverage BytesReceivedAverage
Dynamics Retail – Realtime Service – Client Request Boundary BytesReceivedAverageBase BytesReceivedAverageBase
Dynamics Retail – Realtime Service – Client Request Boundary BytesSent BytesSent
Dynamics Retail – Realtime Service – Client Request Boundary BytesSentAverage BytesSentAverage
Dynamics Retail – Realtime Service – Client Request Boundary BytesSentAverageBase BytesSentAverageBase
Dynamics Retail – Realtime Service – Client Request Boundary FailedCalls FailedCalls
Dynamics Retail – Realtime Service – Client Request Boundary FailedCallsPerSecond FailedCallsPerSecond
Dynamics Retail – Realtime Service – Client Request Boundary FailedCallsRatio FailedCallsRatio
Dynamics Retail – Realtime Service – Client Request Boundary FailedCallsRatioBase FailedCallsRatioBase
Dynamics Retail – Realtime Service – Client Request Boundary LastLatencyInMs LastLatencyInMs
Dynamics Retail – Realtime Service – Client Request Boundary ResultsCount ResultsCount
Dynamics Retail – Realtime Service – Client Request Boundary ResultsCountAverage ResultsCountAverage
Dynamics Retail – Realtime Service – Client Request Boundary ResultsCountAverageBase ResultsCountAverageBase
Dynamics Retail – Realtime Service – Client Request Boundary SucceededCalls SucceededCalls
Dynamics Retail – Realtime Service – Client Request Boundary SucceededCallsPerSecond SucceededCallsPerSecond
Dynamics Retail – Realtime Service – Client Request Boundary SucceededCallsRatio SucceededCallsRatio
Dynamics Retail – Realtime Service – Client Request Boundary SucceededCallsRatioBase SucceededCallsRatioBase
Dynamics Retail – Realtime Service – Client Request Boundary TotalCalls TotalCalls
Dynamics Retail – Realtime Service – Client Request Boundary TotalCallsPerSecond TotalCallsPerSecond
Dynamics Retail – Retail Server – Request Boundary AverageLatencyInMs AverageLatencyInMs
Dynamics Retail – Retail Server – Request Boundary AverageLatencyInMsBase AverageLatencyInMsBase
Dynamics Retail – Retail Server – Request Boundary BytesReceived BytesReceived
Dynamics Retail – Retail Server – Request Boundary BytesReceivedAverage BytesReceivedAverage
Dynamics Retail – Retail Server – Request Boundary BytesReceivedAverageBase BytesReceivedAverageBase
Dynamics Retail – Retail Server – Request Boundary BytesSent BytesSent
Dynamics Retail – Retail Server – Request Boundary BytesSentAverage BytesSentAverage
Dynamics Retail – Retail Server – Request Boundary BytesSentAverageBase BytesSentAverageBase
Dynamics Retail – Retail Server – Request Boundary FailedCalls FailedCalls
Dynamics Retail – Retail Server – Request Boundary FailedCallsPerSecond FailedCallsPerSecond
Dynamics Retail – Retail Server – Request Boundary FailedCallsRatio FailedCallsRatio
Dynamics Retail – Retail Server – Request Boundary FailedCallsRatioBase FailedCallsRatioBase
Dynamics Retail – Retail Server – Request Boundary LastLatencyInMs LastLatencyInMs
Dynamics Retail – Retail Server – Request Boundary SucceededCalls SucceededCalls
Dynamics Retail – Retail Server – Request Boundary SucceededCallsPerSecond SucceededCallsPerSecond
Dynamics Retail – Retail Server – Request Boundary SucceededCallsRatio SucceededCallsRatio
Dynamics Retail – Retail Server – Request Boundary SucceededCallsRatioBase SucceededCallsRatioBase
Dynamics Retail – Retail Server – Request Boundary TotalCalls TotalCalls
Dynamics Retail – Retail Server – Request Boundary TotalCallsPerSecond TotalCallsPerSecond
Management Reporter Archive Age of the oldest generation in minutes by target table name Minutes elapsed since the oldest generation was integrated
Management Reporter Archive Number of records in generation 0 by target table name Number of records in archive generation 0
Management Reporter Archive Number of records in generation 1 by target table name Number of records in archive generation 1
Management Reporter Archive Number of records in generation 2 by target table name Number of records in archive generation 2
Management Reporter Archive Number of records in generation 3 by target table name Number of records in archive generation 3
Management Reporter Archive Number of records in generation 4 by target table name Number of records in archive generation 4
Management Reporter Archive Number of records in generation 5 by target table name Number of records in archive generation 5
Management Reporter Archive Number of records in generation 6 by target table name Number of records in archive generation 6
Management Reporter Archive Number of records in generation 7 by target table name Number of records in archive generation7
Management Reporter Archive Number of records in generation 8+ by target table name Number of records in archive generation 8 or later
Management Reporter Data Mart Cache hits per second Number of cache data requests per second
Management Reporter Data Mart Cache misses per second Number of cache misses per second
Management Reporter Data Mart Cache size Data Mart cache size
Management Reporter Data Mart Combinations per second Number of dimension combinations processed per second
Management Reporter Data Mart Database roundtrips Database roundtrips
Management Reporter Data Mart Failed database requests Failed database requests
Management Reporter Data Mart Opened database connections Number of SQL connections with DDM
Management Reporter Data Mart Report combinations per second Number of combinations per second contained in report
Management Reporter Data Mart Rows processed per second Number of rows processed by account filter transformer per second
Management Reporter Monitors Configuration error Counter incremented when we suspect that the system is incorrectly configured
Management Reporter Monitors System degraded Counter incremented when we suspect that a sub-system is not operating properly
Management Reporter Monitors System down Counter incremented when we suspect that a system down error is encountered
Management Reporter Monitors Transient fault Counter incremented when we suspect that we encounter a transient fault
Management Reporter Reliability Critical events logged per second Critical events logged per second
Management Reporter Reliability Errors logged per second Errors logged per second
Management Reporter Reliability Warnings logged per second Warnings logged per second
Management Reporter Scheduler Concurrent tasks total Number of tasks currently being processed by the scheduler
Management Reporter Scheduler Failed tasks Number of tasks that have failed since service start
Management Reporter Scheduler Queue length immediate tasks Number of tasks in the scheduler queue that are run immediately
Management Reporter Scheduler Queue length scheduled tasks Number of tasks in the scheduler queue that run on a schedule
Management Reporter Scheduler Queue length total Total number of tasks in the scheduler queue
Management Reporter Service Changes read per second by task name Number of changes read per second for each task
Management Reporter Service Changes written per second by task name Number of changes written per second for each task
Management Reporter Service Deleted keys read per second by task name Number of deletions read per second for each task
Management Reporter Service Objects deleted per second by task name Number of deletions written per second for each task
Management Reporter Sql Activity Database roundtrips Database roundtrips
Management Reporter Sql Activity Failed database requests Failed database requests
Management Reporter Sql Activity Opened database connections Number of SQL connections with DDM
Management Reporter Tasks Concurrent tasks by type Number of tasks currently being processed by the scheduler per type
Management Reporter Tasks Queue length by type Number of tasks in the scheduler queue per type
Management Reporter Web Server Requests Active SQL Server connections Current active SQL connections
Management Reporter Web Server Requests Concurrent provider requests Current active provider requests
Management Reporter Web Server Requests Report cache misses Number of cache misses for reports per tick
Management Reporter Web Server Requests Report lines processed The number of report lines processed per tick
Management Reporter Web Server Requests SQL Server request failures Number of SQL request failures
Microsoft Dynamics AX Batch Server Batch heartbeat Batch heartbeat event emiited every minute
Microsoft Dynamics AX Batch Server Batch jobs database polling Counter that tracks the number of times Poll jobs is invoked after throttling
Microsoft Dynamics AX Batch Server Batch jobs executed Total number of Batch jobs executed
Microsoft Dynamics AX Batch Server Batch jobs executed per second Batch jobs executed per second
Microsoft Dynamics AX Batch Server Batch jobs failed Total number of Batch jobs failed
Microsoft Dynamics AX Batch Server Batch jobs failed as percentage of total Batch jobs failed as percentage of total
Microsoft Dynamics AX Batch Server Batch jobs failed as percentage of total Base Batch jobs failed as percentage of total
Microsoft Dynamics AX Batch Server Batch jobs failed per second Batch jobs failed per second
Microsoft Dynamics AX Batch Server Batch jobs schedule failed Total number of Batch jobs schedule failed
Microsoft Dynamics AX Batch Server Batch jobs schedule failed as percentage of total Batch jobs schedule failed as percentage of total
Microsoft Dynamics AX Batch Server Batch jobs schedule failed as percentage of total Base Batch jobs schedule failed as percentage of total
Microsoft Dynamics AX Batch Server Batch jobs schedule failed per second Batch jobs schedule failed per second
Microsoft Dynamics AX Batch Server Batch jobs scheduled Total number of Batch jobs scheduled
Microsoft Dynamics AX Batch Server Batch jobs scheduled per second Batch jobs scheduled per second
Microsoft Dynamics AX Custom Services Average Request Execution Time (ms) Average Request Execution Time (ms)
Microsoft Dynamics AX Custom Services Average Request Execution Time base Average Request Execution Time base
Microsoft Dynamics AX Custom Services Last Request Execution Time (ms) Last Request Execution Time (ms)
Microsoft Dynamics AX Custom Services Request Bytes In Request Bytes In
Microsoft Dynamics AX Custom Services Request Bytes In Average Base Request Bytes In Average Base
Microsoft Dynamics AX Custom Services Request Bytes Out Request Bytes Out
Microsoft Dynamics AX Custom Services Request Bytes Out Average Request Bytes Out Average
Microsoft Dynamics AX Custom Services Request Bytes Out Average Base Request Bytes Out Average Base
Microsoft Dynamics AX Custom Services Request Failure Rate % Request Failure Rate %
Microsoft Dynamics AX Custom Services Requests Failed Requests Failed
Microsoft Dynamics AX Custom Services Requests Failed/Sec Requests Failed/Sec
Microsoft Dynamics AX Custom Services Requests Succeeded Requests Succeeded
Microsoft Dynamics AX Custom Services Requests Succeeded/Sec Requests Succeeded/Sec
Microsoft Dynamics AX Database Slow SQL statements executed Total number of Slow SQL statements executed
Microsoft Dynamics AX Database Slow SQL statements executed as percentage of total Slow SQL statements executed as percentage of total
Microsoft Dynamics AX Database Slow SQL statements executed as percentage of total Base Slow SQL statements executed as percentage of total
Microsoft Dynamics AX Database Slow SQL statements executed Average latency Slow SQL statements executed Average latency
Microsoft Dynamics AX Database Slow SQL statements executed Average latency Base Slow SQL statements executed Average latency
Microsoft Dynamics AX Database Slow SQL statements executed per second Slow SQL statements executed per second
Microsoft Dynamics AX Database SQL Azure retries Total number of SQL Azure retries
Microsoft Dynamics AX Database SQL Azure retries as percentage of total SQL Azure retries as percentage of total
Microsoft Dynamics AX Database SQL Azure retries as percentage of total Base SQL Azure retries as percentage of total
Microsoft Dynamics AX Database SQL Azure retries per second SQL Azure retries per second
Microsoft Dynamics AX Database SQL commits issued Total number of SQL commits issued
Microsoft Dynamics AX Database SQL commits issued per second SQL commits issued per second
Microsoft Dynamics AX Database SQL connection errors Total number of SQL connection errors
Microsoft Dynamics AX Database SQL connection errors per second SQL connection errors per second
Microsoft Dynamics AX Database SQL deadlock errors Total number of SQL deadlock errors
Microsoft Dynamics AX Database SQL deadlock errors as percentage of total SQL deadlock errors as percentage of total
Microsoft Dynamics AX Database SQL deadlock errors as percentage of total Base SQL deadlock errors as percentage of total
Microsoft Dynamics AX Database SQL deadlock errors per second SQL deadlock errors per second
Microsoft Dynamics AX Database SQL duplicate key exceptions Total number of SQL duplicate key exceptions
Microsoft Dynamics AX Database SQL duplicate key exceptions as percentage of total SQL duplicate key exceptions as percentage of total
Microsoft Dynamics AX Database SQL duplicate key exceptions as percentage of total Base SQL duplicate key exceptions as percentage of total
Microsoft Dynamics AX Database SQL duplicate key exceptions per second SQL duplicate key exceptions per second
Microsoft Dynamics AX Database SQL Elastic pool error Total number of SQL Elastic pool error
Microsoft Dynamics AX Database SQL Elastic pool error per second SQL Elastic pool error per second
Microsoft Dynamics AX Database SQL failure: environment Total number of SQL failure most likely caused by an environment issue
Microsoft Dynamics AX Database SQL failure: environment as percentage of total SQL failure most likely caused by an environment issue as percentage of total
Microsoft Dynamics AX Database SQL failure: environment as percentage of total Base SQL failure most likely caused by an environment issue as percentage of total
Microsoft Dynamics AX Database SQL failure: environment per second SQL failure most likely caused by an environment issue per second
Microsoft Dynamics AX Database SQL ODBC errors Total number of SQL ODBC errors
Microsoft Dynamics AX Database SQL ODBC errors per second SQL ODBC errors per second
Microsoft Dynamics AX Database SQL statements executed Total number of SQL statements executed
Microsoft Dynamics AX Database SQL statements executed per second SQL statements executed per second
Microsoft Dynamics AX Database SQL statements failed Total number of SQL statements failed
Microsoft Dynamics AX Database SQL statements failed as percentage of total SQL statements failed as percentage of total
Microsoft Dynamics AX Database SQL statements failed as percentage of total Base SQL statements failed as percentage of total
Microsoft Dynamics AX Database SQL statements failed per second SQL statements failed per second
Microsoft Dynamics AX Database Total Insert queries executed Counter to track the total number of inserts in the AX instance. This counter does not track at the individual table level.
Microsoft Dynamics AX Database Total number of active database connections Total number of active database connections in the AX instance
Microsoft Dynamics AX Database Total number of database transactions Total number of database transactions in the AX instance
Microsoft Dynamics AX Database Total Select queries executed Counter to track the total number of selects in the AX instance. This counter does not track at the individual table level.
Microsoft Dynamics AX Forms # Live FormObservableWrapper Number of currently alive FormObservableWrapper objects
Microsoft Dynamics AX Forms # Live Forms Number of currently open forms.
Microsoft Dynamics AX Forms Avg # Live Forms/Session Average number of forms per session.
Microsoft Dynamics AX Forms Closed Forms/Sec Rate of closing forms per second.
Microsoft Dynamics AX Forms Deleted Forms/Sec Rate of deleting forms per second.
Microsoft Dynamics AX Forms Opened Forms/Sec Rate of openning forms per second.
Microsoft Dynamics AX Forms Total # Closed Forms Total number of closed forms since the server started.
Microsoft Dynamics AX Forms Total # Created Forms Total number of opened forms since the server started.
Microsoft Dynamics AX Forms Total # Deleted Forms Total number of deleted forms since the server started.
Microsoft Dynamics AX Forms Server Request Bytes In Average Request Bytes In Average
Microsoft Dynamics AX Forms Server Request Failure Rate Base Request Failure Rate Base
Microsoft Dynamics AX GC # Live Cursor Proxies Total number of allocated cursor proxies.
Microsoft Dynamics AX GC # Live Cursors Total number of allocated cursors.
Microsoft Dynamics AX GC # Live Kernel X++ Objects Total number of allocated X++ kernel objects.
Microsoft Dynamics AX GC # X++ Collections Number of times X++ GC has been invoked.
Microsoft Dynamics AX GC # X++ Live Kernel Object Proxies Total number of allocated X++ proxies.
Microsoft Dynamics AX GC % Time in X++ GC Percent of CPU time spent in the X++ GC.
Microsoft Dynamics AX GC Allocated Cursors/Second Rate of cursor allocation per second.
Microsoft Dynamics AX GC Allocated Kernel X++ Objects/Second Rate of kernel class allocation per second.
Microsoft Dynamics AX GC Avg # Live Cursors/Session Average number of live cursors per session.
Microsoft Dynamics AX GC Avg # Live X++ Objects/Session Average number of live kernel X++ instances per session.
Microsoft Dynamics AX Server Aos Message File Create Failure Total number of Aos Message File Create Failure
Microsoft Dynamics AX Server Aos Message File Create Failure per second Aos Message File Create Failure per second
Microsoft Dynamics AX Server Aos Session Allocation Error Total number of Aos Session Allocation Error
Microsoft Dynamics AX Server Aos Session Allocation Error per second Aos Session Allocation Error per second
Microsoft Dynamics AX Server Aos Type Load Exception Total number of Aos Type Load Exception
Microsoft Dynamics AX Server Aos Type Load Exception per second Aos Type Load Exception per second
Microsoft Dynamics AX Server Aos Type Reflection Error Total number of Aos Type Reflection Error
Microsoft Dynamics AX Server Aos Type Reflection Error per second Aos Type Reflection Error per second
Microsoft Dynamics AX Server Aos Xpp Method LateBinding Failure Total number of Aos Xpp Method LateBinding Failure
Microsoft Dynamics AX Server Aos Xpp Method LateBinding Failure per second Aos Xpp Method LateBinding Failure per second
Microsoft Dynamics AX Server Exceptions raised Total number of Exceptions raised
Microsoft Dynamics AX Server Exceptions raised per second Exceptions raised per second
Microsoft Dynamics AX Server Total number of Async tasks in Queue Total number of Async tasks in Queue in the AX instance
Microsoft Dynamics AX Server Total number of unique active users Total number of unique users active in the previous 5 minutes
Microsoft Dynamics AX Server Total number of unique users Total number of unique users connected to the system
Microsoft Dynamics AX Server Unhandled exceptions Total number of Unhandled exceptions
Microsoft Dynamics AX Server Unhandled exceptions per second Unhandled exceptions per second
Microsoft Dynamics AX Services Session Provider # Active Sessions Number of active sessions
Microsoft Dynamics AX Services Session Provider # Sessions In Use Number of active sessions in use
Microsoft Dynamics AX Web Client Session Provider Total # Sessions Created Total number of created Sessions

One thing that is interesting is that you can tell that Microsoft has fully embraced the world of IIS with the attention to Late Binding failures – the kind of stuff you often see when dll references aren’t working so well. I’d love to be a little birdie on the wall to hear why Microsoft is prioritizing that so much behind the scenes, but I doubt that information will ever be released publicly. Still, I have to really give Microsoft credit here. I’d love to see more of these tools come into lifecycle services in the cloud version (we already know that they will be there in the on-premise version). This is definitely some very good work.

Till next time.

Videos