Foglight for Active Directory 5.7.2.3 - User and Reference Guide

This view displays additional database access metrics for the selected DC which are gathered when the Database Access collection group is enabled.

I/O Database Average Latency. This graph charts the following metrics:

•

I/O Database Reads Average Latency. Shows the average length of time it takes to perform a database read operation.

•

I/O Database Writes Average Latency. Shows the average length of time it takes to perform a write operation.

Database Page Evictions and Fault Stalls/sec. This graph charts the following metrics:

•

Database Page Evictions/sec. Shows the rate at which database file page requests require the database cache manager to allocate a new page from the database cache forcing another database page out of the cache.

•

Database Page Stalls/sec. Shows the rate at which page faults cannot be serviced because there are no pages available for allocation from the database cache.

Pages and Records Converted. This graph charts the following metrics:

•

Pages Converted. Shows the number of database pages that have been converted from an older format.

•

Records Converted. Shows the number of database records that have been converted from an older format.

Pages and Records Converted/sec. This graph charts the following metrics:

•

Pages Converted/sec. Shows the number of times per second that a database page is converted from an older database format.

•

Records Converted/sec. Shows the number of times per second that a database record is converted from an older database format.

Sessions in Use. This counter shows the number of database sessions currently open for use by client threads.

Sessions % Used. This counter shows the percentage of database sessions currently open for use by client threads.

Version Buckets Allocated. This counter shows the total number of version buckets allocated.

Table Opens/sec. This counter shows the number of database tables opened per second.

Clicking a graph in this view displays a metrics popup that describes the counters, provides more detailed data points, and lists current alarms for the selected metric.

•

Database Cache view

To display this view, enable the Database Cache Group in the Database section of the Metrics Management dashboard. When this collection group is enabled, this view is added to the Database navigation tab for the selected domain controller in the Active Directory Explorer dashboard.

Table 18. Database Cache view

This view displays additional database cache metrics for the selected DC which are gathered when the Database Cache collection group is enabled.

Database Cache/sec. This graph charts the following metrics:

•

Database Cache Misses/sec. Shows the rate at which database file page requests are fulfilled by the database cache by causing a file operation.

•

Database Cache Requests/sec. Shows the rate at which pages are requested from the database cache.

Database Cache Size (MB). This graph charts the following metrics:

•

Database Cache Size (MB). Shows the amount of system memory (in MB) used by the database cache manager to hold commonly used information from the database file(s) to prevent file operations.

•

Database Cache Size Resident (MB). Shows the amount of system memory (in MB) used by the database cache manager that is currently part of the working set of the process.

Database Cache Size. This counter displays the amount of system memory used by the database cache manager to hold commonly used information from the database file(s) to prevent file operations.

Database Cache Size Resident. This counter displays the amount of system memory used by the database cache manager that is currently part of the working set of the process.

Table Open Cache Hits/sec. This counter shows the number of database tables opened per second by using cached schema information.

Table Open Cache Misses/sec. This counter shows the number of database tables opened per second without using cached schema information.

Table Open Cache % Hit. This counter shows the percentage of database tables opened using cached schema information.

Clicking a graph in this view displays a metrics popup that describes the counters, provides more detailed data points, and lists current alarms for the selected metric.

•

Database Log Access view

To display this view, enable the Database Log Access Group in the Database section of the Metrics Management dashboard. When this collection group is enabled, this view is added to the Database navigation tab for the selected domain controller in the Active Directory Explorer dashboard.

Table 19. Database Log Access view

This view displays additional database log access metrics for the selected DC which are gathered when the Database Log Access collection group is enabled.

I/O Log Reads and Writes/sec. This graph charts the following metrics:

•

I/O Log Reads/sec. Shows the rate at which log file read operations are completed.

•

I/O Log Writes/sec. Shows the rate at which log file write operations are completed.

I/O Log Writes Average Latency. This graph charts the average length of time it takes to perform a log file write operation. It provides a comparison against the computed average for the specified time interval.

Log Bytes Generated and Writes/sec. This graph charts the following metrics:

•

Log Bytes Generated/sec. Shows the rate at which data is added to the log.

•

Log Bytes Write/sec. Shows the rate at which bytes are written to the log.

Log Threads Waiting. This graph charts the number of threads waiting on pending log writes. It provides a comparison against the computer average for the specified time interval.

Clicking a graph in this view displays a metrics popup that describes the counters, provides more detailed data points, and lists current alarms for the selected metric.

•

Database Performance Health view

To display this embedded view, select the Database navigation tab for an individual DC in the Active Directory Explorer dashboard.

Table 20. Database Performance Health view

This view displays the database performance metrics for the selected DC. These counters and indicators change colors based on overall consumption or deviation from normal levels.

Database Cache Percent Hit. This graph charts the percent of database page requests handled by the cache for the selected DC. It provides a comparison against the computed average for the specified time interval.

Database Page Faults/sec. This graph charts the rate at which the database file page requests require the database cache manager to allocate a new page from the database cache. It provides a comparison against the computed average for the specified time interval.

I/O Database Reads and Writes/sec. This graph charts the following metrics:

•

I/O Database Reads/sec. Shows the rate at which database read operations completed.

•

I/O Database Writes/sec. Shows the rate at which database write operations completed.

Log Record Stalls/sec. This graph charts the number of log records (per second) that could not be added to the log buffers because the buffers were full. It provides a comparison against the computed average for the specified time interval.

Log Writes/sec. This graph charts the number of times the log buffers are written to the log file per second. It provides a comparison against the computed average for the specified time interval.

Database Size. This button displays the current size of the Active Directory® database.

NTDS.DIT Size. This graph charts the size (in MB) of the database on the selected DC. It provides a comparison against the computed average for the specified time interval.