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.

CategoryNameCounterNameCounter Description
Dynamics Retail – CDX – Apply Offline DataAverageLatencyInMsAverageLatencyInMs
Dynamics Retail – CDX – Apply Offline DataAverageLatencyInMsBaseAverageLatencyInMsBase
Dynamics Retail – CDX – Apply Offline DataBytesReceivedBytesReceived
Dynamics Retail – CDX – Apply Offline DataBytesReceivedAverageBytesReceivedAverage
Dynamics Retail – CDX – Apply Offline DataBytesReceivedAverageBaseBytesReceivedAverageBase
Dynamics Retail – CDX – Apply Offline DataBytesSentBytesSent
Dynamics Retail – CDX – Apply Offline DataBytesSentAverageBytesSentAverage
Dynamics Retail – CDX – Apply Offline DataBytesSentAverageBaseBytesSentAverageBase
Dynamics Retail – CDX – Apply Offline DataFailedCallsFailedCalls
Dynamics Retail – CDX – Apply Offline DataFailedCallsPerSecondFailedCallsPerSecond
Dynamics Retail – CDX – Apply Offline DataFailedCallsRatioFailedCallsRatio
Dynamics Retail – CDX – Apply Offline DataFailedCallsRatioBaseFailedCallsRatioBase
Dynamics Retail – CDX – Apply Offline DataLastLatencyInMsLastLatencyInMs
Dynamics Retail – CDX – Apply Offline DataSucceededCallsSucceededCalls
Dynamics Retail – CDX – Apply Offline DataSucceededCallsPerSecondSucceededCallsPerSecond
Dynamics Retail – CDX – Apply Offline DataSucceededCallsRatioSucceededCallsRatio
Dynamics Retail – CDX – Apply Offline DataSucceededCallsRatioBaseSucceededCallsRatioBase
Dynamics Retail – CDX – Apply Offline DataTotalCallsTotalCalls
Dynamics Retail – CDX – Apply Offline DataTotalCallsPerSecondTotalCallsPerSecond
Dynamics Retail – CDX – Download jobsAverageLatencyInMsAverageLatencyInMs
Dynamics Retail – CDX – Download jobsAverageLatencyInMsBaseAverageLatencyInMsBase
Dynamics Retail – CDX – Download jobsBytesReceivedBytesReceived
Dynamics Retail – CDX – Download jobsBytesReceivedAverageBytesReceivedAverage
Dynamics Retail – CDX – Download jobsBytesReceivedAverageBaseBytesReceivedAverageBase
Dynamics Retail – CDX – Download jobsBytesSentBytesSent
Dynamics Retail – CDX – Download jobsBytesSentAverageBytesSentAverage
Dynamics Retail – CDX – Download jobsBytesSentAverageBaseBytesSentAverageBase
Dynamics Retail – CDX – Download jobsFailedCallsFailedCalls
Dynamics Retail – CDX – Download jobsFailedCallsPerSecondFailedCallsPerSecond
Dynamics Retail – CDX – Download jobsFailedCallsRatioFailedCallsRatio
Dynamics Retail – CDX – Download jobsFailedCallsRatioBaseFailedCallsRatioBase
Dynamics Retail – CDX – Download jobsLastLatencyInMsLastLatencyInMs
Dynamics Retail – CDX – Download jobsSucceededCallsSucceededCalls
Dynamics Retail – CDX – Download jobsSucceededCallsPerSecondSucceededCallsPerSecond
Dynamics Retail – CDX – Download jobsSucceededCallsRatioSucceededCallsRatio
Dynamics Retail – CDX – Download jobsSucceededCallsRatioBaseSucceededCallsRatioBase
Dynamics Retail – CDX – Download jobsTotalCallsTotalCalls
Dynamics Retail – CDX – Download jobsTotalCallsPerSecondTotalCallsPerSecond
Dynamics Retail – CDX – Download Offline DataAverageLatencyInMsAverageLatencyInMs
Dynamics Retail – CDX – Download Offline DataAverageLatencyInMsBaseAverageLatencyInMsBase
Dynamics Retail – CDX – Download Offline DataBytesReceivedBytesReceived
Dynamics Retail – CDX – Download Offline DataBytesReceivedAverageBytesReceivedAverage
Dynamics Retail – CDX – Download Offline DataBytesReceivedAverageBaseBytesReceivedAverageBase
Dynamics Retail – CDX – Download Offline DataBytesSentBytesSent
Dynamics Retail – CDX – Download Offline DataBytesSentAverageBytesSentAverage
Dynamics Retail – CDX – Download Offline DataBytesSentAverageBaseBytesSentAverageBase
Dynamics Retail – CDX – Download Offline DataFailedCallsFailedCalls
Dynamics Retail – CDX – Download Offline DataFailedCallsPerSecondFailedCallsPerSecond
Dynamics Retail – CDX – Download Offline DataFailedCallsRatioFailedCallsRatio
Dynamics Retail – CDX – Download Offline DataFailedCallsRatioBaseFailedCallsRatioBase
Dynamics Retail – CDX – Download Offline DataLastLatencyInMsLastLatencyInMs
Dynamics Retail – CDX – Download Offline DataSucceededCallsSucceededCalls
Dynamics Retail – CDX – Download Offline DataSucceededCallsPerSecondSucceededCallsPerSecond
Dynamics Retail – CDX – Download Offline DataSucceededCallsRatioSucceededCallsRatio
Dynamics Retail – CDX – Download Offline DataSucceededCallsRatioBaseSucceededCallsRatioBase
Dynamics Retail – CDX – Download Offline DataTotalCallsTotalCalls
Dynamics Retail – CDX – Download Offline DataTotalCallsPerSecondTotalCallsPerSecond
Dynamics Retail – CDX – Upload jobAverageLatencyInMsAverageLatencyInMs
Dynamics Retail – CDX – Upload jobAverageLatencyInMsBaseAverageLatencyInMsBase
Dynamics Retail – CDX – Upload jobBytesReceivedBytesReceived
Dynamics Retail – CDX – Upload jobBytesReceivedAverageBytesReceivedAverage
Dynamics Retail – CDX – Upload jobBytesReceivedAverageBaseBytesReceivedAverageBase
Dynamics Retail – CDX – Upload jobBytesSentBytesSent
Dynamics Retail – CDX – Upload jobBytesSentAverageBytesSentAverage
Dynamics Retail – CDX – Upload jobBytesSentAverageBaseBytesSentAverageBase
Dynamics Retail – CDX – Upload jobFailedCallsFailedCalls
Dynamics Retail – CDX – Upload jobFailedCallsPerSecondFailedCallsPerSecond
Dynamics Retail – CDX – Upload jobFailedCallsRatioFailedCallsRatio
Dynamics Retail – CDX – Upload jobFailedCallsRatioBaseFailedCallsRatioBase
Dynamics Retail – CDX – Upload jobLastLatencyInMsLastLatencyInMs
Dynamics Retail – CDX – Upload jobSucceededCallsSucceededCalls
Dynamics Retail – CDX – Upload jobSucceededCallsPerSecondSucceededCallsPerSecond
Dynamics Retail – CDX – Upload jobSucceededCallsRatioSucceededCallsRatio
Dynamics Retail – CDX – Upload jobSucceededCallsRatioBaseSucceededCallsRatioBase
Dynamics Retail – CDX – Upload jobTotalCallsTotalCalls
Dynamics Retail – CDX – Upload jobTotalCallsPerSecondTotalCallsPerSecond
Dynamics Retail – Channel DB – Execute Query BoundaryAverageLatencyInMsAverageLatencyInMs
Dynamics Retail – Channel DB – Execute Query BoundaryAverageLatencyInMsBaseAverageLatencyInMsBase
Dynamics Retail – Channel DB – Execute Query BoundaryFailedCallsFailedCalls
Dynamics Retail – Channel DB – Execute Query BoundaryFailedCallsPerSecondFailedCallsPerSecond
Dynamics Retail – Channel DB – Execute Query BoundaryFailedCallsRatioFailedCallsRatio
Dynamics Retail – Channel DB – Execute Query BoundaryFailedCallsRatioBaseFailedCallsRatioBase
Dynamics Retail – Channel DB – Execute Query BoundaryLastLatencyInMsLastLatencyInMs
Dynamics Retail – Channel DB – Execute Query BoundarySucceededCallsSucceededCalls
Dynamics Retail – Channel DB – Execute Query BoundarySucceededCallsPerSecondSucceededCallsPerSecond
Dynamics Retail – Channel DB – Execute Query BoundarySucceededCallsRatioSucceededCallsRatio
Dynamics Retail – Channel DB – Execute Query BoundarySucceededCallsRatioBaseSucceededCallsRatioBase
Dynamics Retail – Channel DB – Execute Query BoundaryTotalCallsTotalCalls
Dynamics Retail – Channel DB – Execute Query BoundaryTotalCallsPerSecondTotalCallsPerSecond
Dynamics Retail – Channel DB – Stored Proc BoundaryAverageLatencyInMsAverageLatencyInMs
Dynamics Retail – Channel DB – Stored Proc BoundaryAverageLatencyInMsBaseAverageLatencyInMsBase
Dynamics Retail – Channel DB – Stored Proc BoundaryFailedCallsFailedCalls
Dynamics Retail – Channel DB – Stored Proc BoundaryFailedCallsPerSecondFailedCallsPerSecond
Dynamics Retail – Channel DB – Stored Proc BoundaryFailedCallsRatioFailedCallsRatio
Dynamics Retail – Channel DB – Stored Proc BoundaryFailedCallsRatioBaseFailedCallsRatioBase
Dynamics Retail – Channel DB – Stored Proc BoundaryLastLatencyInMsLastLatencyInMs
Dynamics Retail – Channel DB – Stored Proc BoundarySucceededCallsSucceededCalls
Dynamics Retail – Channel DB – Stored Proc BoundarySucceededCallsPerSecondSucceededCallsPerSecond
Dynamics Retail – Channel DB – Stored Proc BoundarySucceededCallsRatioSucceededCallsRatio
Dynamics Retail – Channel DB – Stored Proc BoundarySucceededCallsRatioBaseSucceededCallsRatioBase
Dynamics Retail – Channel DB – Stored Proc BoundaryTotalCallsTotalCalls
Dynamics Retail – Channel DB – Stored Proc BoundaryTotalCallsPerSecondTotalCallsPerSecond
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryAverageLatencyInMsAverageLatencyInMs
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryAverageLatencyInMsBaseAverageLatencyInMsBase
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryBytesReceivedBytesReceived
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryBytesReceivedAverageBytesReceivedAverage
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryBytesReceivedAverageBaseBytesReceivedAverageBase
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryBytesSentBytesSent
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryBytesSentAverageBytesSentAverage
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryBytesSentAverageBaseBytesSentAverageBase
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryFailedCallsFailedCalls
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryFailedCallsPerSecondFailedCallsPerSecond
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryFailedCallsRatioFailedCallsRatio
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryFailedCallsRatioBaseFailedCallsRatioBase
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryLastLatencyInMsLastLatencyInMs
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryResultsCountResultsCount
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryResultsCountAverageResultsCountAverage
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryResultsCountAverageBaseResultsCountAverageBase
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundarySucceededCallsSucceededCalls
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundarySucceededCallsPerSecondSucceededCallsPerSecond
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundarySucceededCallsRatioSucceededCallsRatio
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundarySucceededCallsRatioBaseSucceededCallsRatioBase
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryTotalCallsTotalCalls
Dynamics Retail – Cortana Intelligence – Recommendation Request BoundaryTotalCallsPerSecondTotalCallsPerSecond
Dynamics Retail – Realtime Async Service – Client Request BoundaryAverageLatencyInMsAverageLatencyInMs
Dynamics Retail – Realtime Async Service – Client Request BoundaryAverageLatencyInMsBaseAverageLatencyInMsBase
Dynamics Retail – Realtime Async Service – Client Request BoundaryBytesReceivedBytesReceived
Dynamics Retail – Realtime Async Service – Client Request BoundaryBytesReceivedAverageBytesReceivedAverage
Dynamics Retail – Realtime Async Service – Client Request BoundaryBytesReceivedAverageBaseBytesReceivedAverageBase
Dynamics Retail – Realtime Async Service – Client Request BoundaryBytesSentBytesSent
Dynamics Retail – Realtime Async Service – Client Request BoundaryBytesSentAverageBytesSentAverage
Dynamics Retail – Realtime Async Service – Client Request BoundaryBytesSentAverageBaseBytesSentAverageBase
Dynamics Retail – Realtime Async Service – Client Request BoundaryFailedCallsFailedCalls
Dynamics Retail – Realtime Async Service – Client Request BoundaryFailedCallsPerSecondFailedCallsPerSecond
Dynamics Retail – Realtime Async Service – Client Request BoundaryFailedCallsRatioFailedCallsRatio
Dynamics Retail – Realtime Async Service – Client Request BoundaryFailedCallsRatioBaseFailedCallsRatioBase
Dynamics Retail – Realtime Async Service – Client Request BoundaryLastLatencyInMsLastLatencyInMs
Dynamics Retail – Realtime Async Service – Client Request BoundarySucceededCallsSucceededCalls
Dynamics Retail – Realtime Async Service – Client Request BoundarySucceededCallsPerSecondSucceededCallsPerSecond
Dynamics Retail – Realtime Async Service – Client Request BoundarySucceededCallsRatioSucceededCallsRatio
Dynamics Retail – Realtime Async Service – Client Request BoundarySucceededCallsRatioBaseSucceededCallsRatioBase
Dynamics Retail – Realtime Async Service – Client Request BoundaryTotalCallsTotalCalls
Dynamics Retail – Realtime Async Service – Client Request BoundaryTotalCallsPerSecondTotalCallsPerSecond
Dynamics Retail – Realtime Service – Client Request BoundaryAverageLatencyInMsAverageLatencyInMs
Dynamics Retail – Realtime Service – Client Request BoundaryAverageLatencyInMsBaseAverageLatencyInMsBase
Dynamics Retail – Realtime Service – Client Request BoundaryBytesReceivedBytesReceived
Dynamics Retail – Realtime Service – Client Request BoundaryBytesReceivedAverageBytesReceivedAverage
Dynamics Retail – Realtime Service – Client Request BoundaryBytesReceivedAverageBaseBytesReceivedAverageBase
Dynamics Retail – Realtime Service – Client Request BoundaryBytesSentBytesSent
Dynamics Retail – Realtime Service – Client Request BoundaryBytesSentAverageBytesSentAverage
Dynamics Retail – Realtime Service – Client Request BoundaryBytesSentAverageBaseBytesSentAverageBase
Dynamics Retail – Realtime Service – Client Request BoundaryFailedCallsFailedCalls
Dynamics Retail – Realtime Service – Client Request BoundaryFailedCallsPerSecondFailedCallsPerSecond
Dynamics Retail – Realtime Service – Client Request BoundaryFailedCallsRatioFailedCallsRatio
Dynamics Retail – Realtime Service – Client Request BoundaryFailedCallsRatioBaseFailedCallsRatioBase
Dynamics Retail – Realtime Service – Client Request BoundaryLastLatencyInMsLastLatencyInMs
Dynamics Retail – Realtime Service – Client Request BoundaryResultsCountResultsCount
Dynamics Retail – Realtime Service – Client Request BoundaryResultsCountAverageResultsCountAverage
Dynamics Retail – Realtime Service – Client Request BoundaryResultsCountAverageBaseResultsCountAverageBase
Dynamics Retail – Realtime Service – Client Request BoundarySucceededCallsSucceededCalls
Dynamics Retail – Realtime Service – Client Request BoundarySucceededCallsPerSecondSucceededCallsPerSecond
Dynamics Retail – Realtime Service – Client Request BoundarySucceededCallsRatioSucceededCallsRatio
Dynamics Retail – Realtime Service – Client Request BoundarySucceededCallsRatioBaseSucceededCallsRatioBase
Dynamics Retail – Realtime Service – Client Request BoundaryTotalCallsTotalCalls
Dynamics Retail – Realtime Service – Client Request BoundaryTotalCallsPerSecondTotalCallsPerSecond
Dynamics Retail – Retail Server – Request BoundaryAverageLatencyInMsAverageLatencyInMs
Dynamics Retail – Retail Server – Request BoundaryAverageLatencyInMsBaseAverageLatencyInMsBase
Dynamics Retail – Retail Server – Request BoundaryBytesReceivedBytesReceived
Dynamics Retail – Retail Server – Request BoundaryBytesReceivedAverageBytesReceivedAverage
Dynamics Retail – Retail Server – Request BoundaryBytesReceivedAverageBaseBytesReceivedAverageBase
Dynamics Retail – Retail Server – Request BoundaryBytesSentBytesSent
Dynamics Retail – Retail Server – Request BoundaryBytesSentAverageBytesSentAverage
Dynamics Retail – Retail Server – Request BoundaryBytesSentAverageBaseBytesSentAverageBase
Dynamics Retail – Retail Server – Request BoundaryFailedCallsFailedCalls
Dynamics Retail – Retail Server – Request BoundaryFailedCallsPerSecondFailedCallsPerSecond
Dynamics Retail – Retail Server – Request BoundaryFailedCallsRatioFailedCallsRatio
Dynamics Retail – Retail Server – Request BoundaryFailedCallsRatioBaseFailedCallsRatioBase
Dynamics Retail – Retail Server – Request BoundaryLastLatencyInMsLastLatencyInMs
Dynamics Retail – Retail Server – Request BoundarySucceededCallsSucceededCalls
Dynamics Retail – Retail Server – Request BoundarySucceededCallsPerSecondSucceededCallsPerSecond
Dynamics Retail – Retail Server – Request BoundarySucceededCallsRatioSucceededCallsRatio
Dynamics Retail – Retail Server – Request BoundarySucceededCallsRatioBaseSucceededCallsRatioBase
Dynamics Retail – Retail Server – Request BoundaryTotalCallsTotalCalls
Dynamics Retail – Retail Server – Request BoundaryTotalCallsPerSecondTotalCallsPerSecond
Management Reporter ArchiveAge of the oldest generation in minutes by target table nameMinutes elapsed since the oldest generation was integrated
Management Reporter ArchiveNumber of records in generation 0 by target table nameNumber of records in archive generation 0
Management Reporter ArchiveNumber of records in generation 1 by target table nameNumber of records in archive generation 1
Management Reporter ArchiveNumber of records in generation 2 by target table nameNumber of records in archive generation 2
Management Reporter ArchiveNumber of records in generation 3 by target table nameNumber of records in archive generation 3
Management Reporter ArchiveNumber of records in generation 4 by target table nameNumber of records in archive generation 4
Management Reporter ArchiveNumber of records in generation 5 by target table nameNumber of records in archive generation 5
Management Reporter ArchiveNumber of records in generation 6 by target table nameNumber of records in archive generation 6
Management Reporter ArchiveNumber of records in generation 7 by target table nameNumber of records in archive generation7
Management Reporter ArchiveNumber of records in generation 8+ by target table nameNumber of records in archive generation 8 or later
Management Reporter Data MartCache hits per secondNumber of cache data requests per second
Management Reporter Data MartCache misses per secondNumber of cache misses per second
Management Reporter Data MartCache sizeData Mart cache size
Management Reporter Data MartCombinations per secondNumber of dimension combinations processed per second
Management Reporter Data MartDatabase roundtripsDatabase roundtrips
Management Reporter Data MartFailed database requestsFailed database requests
Management Reporter Data MartOpened database connectionsNumber of SQL connections with DDM
Management Reporter Data MartReport combinations per secondNumber of combinations per second contained in report
Management Reporter Data MartRows processed per secondNumber of rows processed by account filter transformer per second
Management Reporter MonitorsConfiguration errorCounter incremented when we suspect that the system is incorrectly configured
Management Reporter MonitorsSystem degradedCounter incremented when we suspect that a sub-system is not operating properly
Management Reporter MonitorsSystem downCounter incremented when we suspect that a system down error is encountered
Management Reporter MonitorsTransient faultCounter incremented when we suspect that we encounter a transient fault
Management Reporter ReliabilityCritical events logged per secondCritical events logged per second
Management Reporter ReliabilityErrors logged per secondErrors logged per second
Management Reporter ReliabilityWarnings logged per secondWarnings logged per second
Management Reporter SchedulerConcurrent tasks totalNumber of tasks currently being processed by the scheduler
Management Reporter SchedulerFailed tasksNumber of tasks that have failed since service start
Management Reporter SchedulerQueue length immediate tasksNumber of tasks in the scheduler queue that are run immediately
Management Reporter SchedulerQueue length scheduled tasksNumber of tasks in the scheduler queue that run on a schedule
Management Reporter SchedulerQueue length totalTotal number of tasks in the scheduler queue
Management Reporter ServiceChanges read per second by task nameNumber of changes read per second for each task
Management Reporter ServiceChanges written per second by task nameNumber of changes written per second for each task
Management Reporter ServiceDeleted keys read per second by task nameNumber of deletions read per second for each task
Management Reporter ServiceObjects deleted per second by task nameNumber of deletions written per second for each task
Management Reporter Sql ActivityDatabase roundtripsDatabase roundtrips
Management Reporter Sql ActivityFailed database requestsFailed database requests
Management Reporter Sql ActivityOpened database connectionsNumber of SQL connections with DDM
Management Reporter TasksConcurrent tasks by typeNumber of tasks currently being processed by the scheduler per type
Management Reporter TasksQueue length by typeNumber of tasks in the scheduler queue per type
Management Reporter Web Server RequestsActive SQL Server connectionsCurrent active SQL connections
Management Reporter Web Server RequestsConcurrent provider requestsCurrent active provider requests
Management Reporter Web Server RequestsReport cache missesNumber of cache misses for reports per tick
Management Reporter Web Server RequestsReport lines processedThe number of report lines processed per tick
Management Reporter Web Server RequestsSQL Server request failuresNumber of SQL request failures
Microsoft Dynamics AX Batch ServerBatch heartbeatBatch heartbeat event emiited every minute
Microsoft Dynamics AX Batch ServerBatch jobs database pollingCounter that tracks the number of times Poll jobs is invoked after throttling
Microsoft Dynamics AX Batch ServerBatch jobs executedTotal number of Batch jobs executed
Microsoft Dynamics AX Batch ServerBatch jobs executed per secondBatch jobs executed per second
Microsoft Dynamics AX Batch ServerBatch jobs failedTotal number of Batch jobs failed
Microsoft Dynamics AX Batch ServerBatch jobs failed as percentage of totalBatch jobs failed as percentage of total
Microsoft Dynamics AX Batch ServerBatch jobs failed as percentage of total BaseBatch jobs failed as percentage of total
Microsoft Dynamics AX Batch ServerBatch jobs failed per secondBatch jobs failed per second
Microsoft Dynamics AX Batch ServerBatch jobs schedule failedTotal number of Batch jobs schedule failed
Microsoft Dynamics AX Batch ServerBatch jobs schedule failed as percentage of totalBatch jobs schedule failed as percentage of total
Microsoft Dynamics AX Batch ServerBatch jobs schedule failed as percentage of total BaseBatch jobs schedule failed as percentage of total
Microsoft Dynamics AX Batch ServerBatch jobs schedule failed per secondBatch jobs schedule failed per second
Microsoft Dynamics AX Batch ServerBatch jobs scheduledTotal number of Batch jobs scheduled
Microsoft Dynamics AX Batch ServerBatch jobs scheduled per secondBatch jobs scheduled per second
Microsoft Dynamics AX Custom ServicesAverage Request Execution Time (ms)Average Request Execution Time (ms)
Microsoft Dynamics AX Custom ServicesAverage Request Execution Time baseAverage Request Execution Time base
Microsoft Dynamics AX Custom ServicesLast Request Execution Time (ms)Last Request Execution Time (ms)
Microsoft Dynamics AX Custom ServicesRequest Bytes InRequest Bytes In
Microsoft Dynamics AX Custom ServicesRequest Bytes In Average BaseRequest Bytes In Average Base
Microsoft Dynamics AX Custom ServicesRequest Bytes OutRequest Bytes Out
Microsoft Dynamics AX Custom ServicesRequest Bytes Out AverageRequest Bytes Out Average
Microsoft Dynamics AX Custom ServicesRequest Bytes Out Average BaseRequest Bytes Out Average Base
Microsoft Dynamics AX Custom ServicesRequest Failure Rate %Request Failure Rate %
Microsoft Dynamics AX Custom ServicesRequests FailedRequests Failed
Microsoft Dynamics AX Custom ServicesRequests Failed/SecRequests Failed/Sec
Microsoft Dynamics AX Custom ServicesRequests SucceededRequests Succeeded
Microsoft Dynamics AX Custom ServicesRequests Succeeded/SecRequests Succeeded/Sec
Microsoft Dynamics AX DatabaseSlow SQL statements executedTotal number of Slow SQL statements executed
Microsoft Dynamics AX DatabaseSlow SQL statements executed as percentage of totalSlow SQL statements executed as percentage of total
Microsoft Dynamics AX DatabaseSlow SQL statements executed as percentage of total BaseSlow SQL statements executed as percentage of total
Microsoft Dynamics AX DatabaseSlow SQL statements executed Average latencySlow SQL statements executed Average latency
Microsoft Dynamics AX DatabaseSlow SQL statements executed Average latency BaseSlow SQL statements executed Average latency
Microsoft Dynamics AX DatabaseSlow SQL statements executed per secondSlow SQL statements executed per second
Microsoft Dynamics AX DatabaseSQL Azure retriesTotal number of SQL Azure retries
Microsoft Dynamics AX DatabaseSQL Azure retries as percentage of totalSQL Azure retries as percentage of total
Microsoft Dynamics AX DatabaseSQL Azure retries as percentage of total BaseSQL Azure retries as percentage of total
Microsoft Dynamics AX DatabaseSQL Azure retries per secondSQL Azure retries per second
Microsoft Dynamics AX DatabaseSQL commits issuedTotal number of SQL commits issued
Microsoft Dynamics AX DatabaseSQL commits issued per secondSQL commits issued per second
Microsoft Dynamics AX DatabaseSQL connection errorsTotal number of SQL connection errors
Microsoft Dynamics AX DatabaseSQL connection errors per secondSQL connection errors per second
Microsoft Dynamics AX DatabaseSQL deadlock errorsTotal number of SQL deadlock errors
Microsoft Dynamics AX DatabaseSQL deadlock errors as percentage of totalSQL deadlock errors as percentage of total
Microsoft Dynamics AX DatabaseSQL deadlock errors as percentage of total BaseSQL deadlock errors as percentage of total
Microsoft Dynamics AX DatabaseSQL deadlock errors per secondSQL deadlock errors per second
Microsoft Dynamics AX DatabaseSQL duplicate key exceptionsTotal number of SQL duplicate key exceptions
Microsoft Dynamics AX DatabaseSQL duplicate key exceptions as percentage of totalSQL duplicate key exceptions as percentage of total
Microsoft Dynamics AX DatabaseSQL duplicate key exceptions as percentage of total BaseSQL duplicate key exceptions as percentage of total
Microsoft Dynamics AX DatabaseSQL duplicate key exceptions per secondSQL duplicate key exceptions per second
Microsoft Dynamics AX DatabaseSQL Elastic pool errorTotal number of SQL Elastic pool error
Microsoft Dynamics AX DatabaseSQL Elastic pool error per secondSQL Elastic pool error per second
Microsoft Dynamics AX DatabaseSQL failure: environmentTotal number of SQL failure most likely caused by an environment issue
Microsoft Dynamics AX DatabaseSQL failure: environment as percentage of totalSQL failure most likely caused by an environment issue as percentage of total
Microsoft Dynamics AX DatabaseSQL failure: environment as percentage of total BaseSQL failure most likely caused by an environment issue as percentage of total
Microsoft Dynamics AX DatabaseSQL failure: environment per secondSQL failure most likely caused by an environment issue per second
Microsoft Dynamics AX DatabaseSQL ODBC errorsTotal number of SQL ODBC errors
Microsoft Dynamics AX DatabaseSQL ODBC errors per secondSQL ODBC errors per second
Microsoft Dynamics AX DatabaseSQL statements executedTotal number of SQL statements executed
Microsoft Dynamics AX DatabaseSQL statements executed per secondSQL statements executed per second
Microsoft Dynamics AX DatabaseSQL statements failedTotal number of SQL statements failed
Microsoft Dynamics AX DatabaseSQL statements failed as percentage of totalSQL statements failed as percentage of total
Microsoft Dynamics AX DatabaseSQL statements failed as percentage of total BaseSQL statements failed as percentage of total
Microsoft Dynamics AX DatabaseSQL statements failed per secondSQL statements failed per second
Microsoft Dynamics AX DatabaseTotal Insert queries executedCounter to track the total number of inserts in the AX instance. This counter does not track at the individual table level.
Microsoft Dynamics AX DatabaseTotal number of active database connectionsTotal number of active database connections in the AX instance
Microsoft Dynamics AX DatabaseTotal number of database transactionsTotal number of database transactions in the AX instance
Microsoft Dynamics AX DatabaseTotal Select queries executedCounter 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 FormObservableWrapperNumber of currently alive FormObservableWrapper objects
Microsoft Dynamics AX Forms# Live FormsNumber of currently open forms.
Microsoft Dynamics AX FormsAvg # Live Forms/SessionAverage number of forms per session.
Microsoft Dynamics AX FormsClosed Forms/SecRate of closing forms per second.
Microsoft Dynamics AX FormsDeleted Forms/SecRate of deleting forms per second.
Microsoft Dynamics AX FormsOpened Forms/SecRate of openning forms per second.
Microsoft Dynamics AX FormsTotal # Closed FormsTotal number of closed forms since the server started.
Microsoft Dynamics AX FormsTotal # Created FormsTotal number of opened forms since the server started.
Microsoft Dynamics AX FormsTotal # Deleted FormsTotal number of deleted forms since the server started.
Microsoft Dynamics AX Forms ServerRequest Bytes In AverageRequest Bytes In Average
Microsoft Dynamics AX Forms ServerRequest Failure Rate BaseRequest Failure Rate Base
Microsoft Dynamics AX GC# Live Cursor ProxiesTotal number of allocated cursor proxies.
Microsoft Dynamics AX GC# Live CursorsTotal number of allocated cursors.
Microsoft Dynamics AX GC# Live Kernel X++ ObjectsTotal number of allocated X++ kernel objects.
Microsoft Dynamics AX GC# X++ CollectionsNumber of times X++ GC has been invoked.
Microsoft Dynamics AX GC# X++ Live Kernel Object ProxiesTotal number of allocated X++ proxies.
Microsoft Dynamics AX GC% Time in X++ GCPercent of CPU time spent in the X++ GC.
Microsoft Dynamics AX GCAllocated Cursors/SecondRate of cursor allocation per second.
Microsoft Dynamics AX GCAllocated Kernel X++ Objects/SecondRate of kernel class allocation per second.
Microsoft Dynamics AX GCAvg # Live Cursors/SessionAverage number of live cursors per session.
Microsoft Dynamics AX GCAvg # Live X++ Objects/SessionAverage number of live kernel X++ instances per session.
Microsoft Dynamics AX ServerAos Message File Create FailureTotal number of Aos Message File Create Failure
Microsoft Dynamics AX ServerAos Message File Create Failure per secondAos Message File Create Failure per second
Microsoft Dynamics AX ServerAos Session Allocation ErrorTotal number of Aos Session Allocation Error
Microsoft Dynamics AX ServerAos Session Allocation Error per secondAos Session Allocation Error per second
Microsoft Dynamics AX ServerAos Type Load ExceptionTotal number of Aos Type Load Exception
Microsoft Dynamics AX ServerAos Type Load Exception per secondAos Type Load Exception per second
Microsoft Dynamics AX ServerAos Type Reflection ErrorTotal number of Aos Type Reflection Error
Microsoft Dynamics AX ServerAos Type Reflection Error per secondAos Type Reflection Error per second
Microsoft Dynamics AX ServerAos Xpp Method LateBinding FailureTotal number of Aos Xpp Method LateBinding Failure
Microsoft Dynamics AX ServerAos Xpp Method LateBinding Failure per secondAos Xpp Method LateBinding Failure per second
Microsoft Dynamics AX ServerExceptions raisedTotal number of Exceptions raised
Microsoft Dynamics AX ServerExceptions raised per secondExceptions raised per second
Microsoft Dynamics AX ServerTotal number of Async tasks in QueueTotal number of Async tasks in Queue in the AX instance
Microsoft Dynamics AX ServerTotal number of unique active usersTotal number of unique users active in the previous 5 minutes
Microsoft Dynamics AX ServerTotal number of unique usersTotal number of unique users connected to the system
Microsoft Dynamics AX ServerUnhandled exceptionsTotal number of Unhandled exceptions
Microsoft Dynamics AX ServerUnhandled exceptions per secondUnhandled exceptions per second
Microsoft Dynamics AX Services Session Provider# Active SessionsNumber of active sessions
Microsoft Dynamics AX Services Session Provider# Sessions In UseNumber of active sessions in use
Microsoft Dynamics AX Web Client Session ProviderTotal # Sessions CreatedTotal 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.