These counters describe the activity of the Extensible Storage Engine (ESE), a transacted database system that stores all Microsoft® Active Directory® objects, can access a performance object (the Database object) that provides counters to measure the activity of the ESE. This object is not installed by default and needs to be installed using Lodctr.exe in the Platform SDK. Values are only reported for processes that use the ESE.
The Database object provides performance statistics for each process using the ESE high performance embedded database management system. This section does not describe counters that are for developer use only.
| Counter Name | Description | Counter Type |
|---|---|---|
| Cache % Hit | Shows the percentage of database file page requests that were fulfilled by the database cache without causing a file operation. If this percentage is too low, the database cache size may be too small. | PERF_SAMPLE_FRACTION |
| Cache Page Fault Stalls/sec | Shows the number of page faults per second that cannot be serviced because there are no pages available for allocation from the database cache. If this counter is nonzero most of the time, the clean threshold may be too low. | PERF_COUNTER_COUNTER |
| Cache Page Faults/sec | Shows the number of database file page requests that require the database cache manager to allocate a new page from the database cache. If this rate is too high, the database cache size may be too small. | PERF_COUNTER_COUNTER |
| Cache Size | Shows 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. If the database cache size seems to be too small for optimal performance and there is very little available memory on the system (see Memory\Available Bytes), adding more memory to the system may increase performance. If there is a lot of available memory on the system and the database cache size is not growing beyond a certain point, the database cache size may be capped at an artificially low limit. Increasing this limit may increase performance. | PERF_COUNTER_RAWCOUNT |
| File Bytes Read/sec | Shows the rate at which bytes are read from the database file(s) into the database cache per second. If this rate is too high, the database cache size may be too small. | PERF_COUNTER_COUNTER |
| File Bytes Written/sec | Shows the rate at which bytes are written to the database file(s) from the database cache per second. If this rate is too high, the database cache size may be too small. | PERF_COUNTER_COUNTER |
| File Operations Pending | Shows the number of reads and writes issued by the database cache manager to the database file(s) that are currently being processed by the operating system. A large number of pending file operations can increase system throughput but will increase response time for individual operations. Typically, a larger number means that file operations to the database file(s) may be a bottleneck. | PERF_COUNTER_RAWCOUNT |
| File Operations/sec | Shows the number of reads and writes issued by the database cache manager to the database file(s) per second. If this rate is too high, the database cache size may be too small. | PERF_COUNTER_COUNTER |
| Log Record Stalls/sec | Shows the number of log records that cannot be added to the log buffers per second because they are full. If this counter is nonzero most of the time, the log buffer size may be a bottleneck. | PERF_COUNTER_COUNTER |
| Log Threads Waiting | Shows the number of threads waiting for their data to be written to the log to complete an update of the database. If this number is too high, the log may be a bottleneck. | PERF_COUNTER_RAWCOUNT |
| Log Writes/sec | Shows the number of times that the log buffers are written to the log file(s) per second. If this number approaches the maximum write rate for the media holding the log file(s), the log may be a bottleneck. | PERF_COUNTER_COUNTER |
| Table Open Cache % Hit | Shows the percentage of database tables opened using cached schema information. If this percentage is too low, the table cache size may be too small. | PERF_SAMPLE_FRACTION |
| Table Open Cache Hits/sec | Shows the number of database tables opened using cached schema information per second. If this rate is too low, the table cache size may be too small. | PERF_COUNTER_COUNTER |
| Table Open Cache Misses/sec | Shows the number of database tables opened without using cached schema information per second. If this rate is too high, the table cache size may be too small. | PERF_COUNTER_COUNTER |
| Table Opens/sec | Shows the number of database tables opened per second. | PERF_COUNTER_COUNTER |