Contact Info

Crumbtrail

ActiveXperts.com » Administration » Microsoft Dynamics » AX

Microsoft Dynamics AX Performance Counters

Microsoft Dynamics Dynamics AX SQL Server counters

The following table lists the counters that are typically monitored for SQL Server.

Counter Name Description
Counter Name: Batch Requests/sec Description: Object: SQLServer:SQL Statistics
Counter Name: Buffer Cache hit ratio Description: Object: SQL Server:Buffer Manager
Counter Name: Forwarded Records/sec Description: Object: SQLServer:Access Methods
Counter Name: Free list stalls/sec Description: Object: SQL Server:Buffer Manager
Counter Name: FreeSpace Scans/sec Description: Object: SQLServer:Access Methods
Counter Name: Full Scans/sec Description: Object: SQLServer:Access Methods
Counter Name: Lazy Writes/sec Description: Object: SQL Server:Buffer Manager
Counter Name: Lock Requests/sec Description: Object: SQL Server:Locks
Counter Name: Page Life Expectancy Description: Object: SQL Server:Buffer Manager
Counter Name: Page lookups/sec Description: Object: SQL Server:Buffer Manager
Counter Name: SQL Compilations/sec Description: Object: SQLServer:SQL Statistics
Counter Name: SQL Re-Compilations/sec Description: Object: SQLServer:SQL Statistics
Counter Name: Workfiles Created/sec Description: Object: SQLServer:Access Methods
Counter Name: Worktables Created/sec Description: Object: SQLServer:Access Methods