| Counter Name: # Calculated fields cache total requests |
Description: |
| Counter Name: # Command cache total requests |
Description: Count of the total number of requests to the command cache. The command cache contains the results of all SQL commands. |
| Counter Name: # Open connections |
Description: Count of the current number of open connections to the Microsoft Dynamics NAV Server instance. |
| Counter Name: # Preferred connection total requests |
Description: Count of the total number of requests to the preferred connection cache. The preferred connection cache contains requests from the SQL connection pool that was last used by a Microsoft Dynamics NAV user. |
| Counter Name: # Primary key cache total requests |
Description: Count of the total number of requests to the primary key cache. The primary key cache contains the results of requests to get a record by using its primary key. |
| Counter Name: # Result set cache total requests |
Description: Count of the total number of requests to the result set cache. The result set cache contains result sets that are returned from SQL Server. |
| Counter Name: # Rows in all temporary tables |
Description: Count of number of rows in all temporary tables. |
| Counter Name: % Calculated fields cache hit rate |
Description: Percentage of hits in the calculated fields cache, compared to the total requests to the calculated fields cache. |
| Counter Name: % Command cache hit rate |
Description: Percentage of hits in the command cache, compared to the total requests to the command cache. |
| Counter Name: % Preferred connection cache hit rate |
Description: Percentage of hits in the preferred connection cache, compared to the total number of requests. |
| Counter Name: % Primary key cache hit rate |
Description: Percentage of hits in the primary key cache, compared to the total requests to the primary key cache. |
| Counter Name: % Query repositioning rate |
Description: Percentage of queries that are re-executed when fetching the query result. |
| Counter Name: % Result set cache hit rate |
Description: Percentage of hits in the result set cache, compared to the total requests to the result set cache. |
| Counter Name: Hard throttled connections |
Description: Number of connections in which a SQL Server limit was exceeded. An example of a SQL Server limit is the amount of log space available.
If you have a hard throttled connection, you must take action to reduce whatever limit was hit before you retry the operation, otherwise, you will continue to hit the limit. |
| Counter Name: Heartbeat time (ms) |
Description: The time it takes to complete a single write to a system table. Every 30 seconds, the Microsoft Dynamics NAV Server instance writes a record to indicate that the instance is "alive."
You can use this counter to get an indication of the network latency between the Microsoft Dynamics NAV Server and the SQL Server. |
| Counter Name: Soft throttled connections |
Description: Number of connections in which the SQL Server is temporarily unable to complete an operation. If you have a soft throttled connection, you must retry the operation. |
| Counter Name: Transient errors |
Description: Count of the number of times Microsoft Dynamics NAV encountered a transient error. A transient error indicates that SQL Server was temporarily unavailable, for example, because of a failover or because of network issues.
If a transient error breaks a connection to the SQL Server, then the connection is automatically re-established. |
