# Calculated fields cache total requests

Count of the total number of requests to the calculated fields cache. The calculated fields cache contains the results of CALCFIELDS Function (Record) calls.

% Calculated fields cache hit rate

Percentage of hits in the calculated fields cache, compared to the total requests to the calculated fields cache.

# Command cache total requests

Count of the total number of requests to the command cache. The command cache contains the results of all SQL commands.

% Command cache hit rate

Percentage of hits in the command cache, compared to the total requests to the command cache.

# Open connections

Count of the current number of open connections to the Microsoft Dynamics NAV Server instance.

# Preferred connection total requests

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.

% Preferred connection cache hit rate

Percentage of hits in the preferred connection cache, compared to the total number of requests.

# Primary key cache total requests

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.

% Primary key cache hit rate

Percentage of hits in the primary key cache, compared to the total requests to the primary key cache.

# Result set cache total requests

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.

% Result set cache hit rate

Percentage of hits in the result set cache, compared to the total requests to the result set cache.

# Rows in all temporary tables

Count of number of rows in all temporary tables.

% Query repositioning rate

Percentage of queries that are re-executed when fetching the query result.

Hard throttled connections

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.

Heartbeat time (ms)

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.

Soft throttled connections

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.

Transient errors

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.