- WMI Library -
WMI Libraly > Win32_PerfFormattedData_ESENT_Database Class

Win32_PerfFormattedData_ESENT_Database Class

Database provides performance statistics for each process using the ESE high performance embedded database management system.
Namespace value is root/CIMV2.
WMI Provider value is WmiPerfInst.


Properties

  • Caption
  • A short textual description (one-line string) for the statistic or metric.

  • DatabaseCacheMissesPersec
  • Database Cache Misses per second is the rate at which database file page requests were fulfilled by the database cache by causing a file operation. If this rate is high then the database cache size may be too small.

  • DatabaseCachePercentHit
  • Database Cache % Hit is 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.

  • DatabaseCacheRequestsPersec
  • Database Cache Requests/sec is the rate that pages are requested from the database cache.

  • DatabaseCacheSize
  • Database Cache Size is 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.

  • DatabaseCacheSizeMB
  • Database Cache Size (MB) is the amount of system memory (in MegaBytes) 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.

  • DatabaseCacheSizeResident
  • Database Cache Size Resident is the amount of system memory used by the database cache that is currently part of the working set of the process. If Database Cache Size Resident is ever significantly smaller than Database Cache Size then the operating system has chosen to reclaim that system memory for use in other parts of the system. The database cache will recover from this event but if this is a common occurrence then it can lead to significant performance problems.

  • DatabaseCacheSizeResidentMB
  • Database Cache Size Resident (MB) is the amount of system memory (in MegaBytes) used by the database cache that is currently part of the working set of the process. If Database Cache Size Resident (MB) is ever significantly smaller than Database Cache Size (MB) then the operating system has chosen to reclaim that system memory for use in other parts of the system. The database cache will recover from this event but if this is a common occurrence then it can lead to significant performance problems.

  • DatabasePageEvictionsPersec
  • Database Page Evictions/sec is the rate that database file page requests that require the database cache manager to allocate a new page from the database cache force another database page out of the cache. The eviction count is charged when the page is allocated and not when the previous owner of that page was actually evicted from the cache. If this rate is too high, the database cache size may be too small.

  • DatabasePageFaultsPersec
  • Database Page Faults/sec is the rate that database file page requests require the database cache manager to allocate a new page from the database cache.

  • DatabasePageFaultStallsPersec
  • Database Page Fault Stalls/sec is the rate of page faults that cannot be serviced because there are no pages available for allocation from the database cache. If this counter is non-zero most of the time, the clean threshold may be too low.

  • DefragmentationTasks
  • Defragmentation Tasks is the count of background database defragmentation tasks that are currently executing.

  • DefragmentationTasksPending
  • Defragmentation Tasks Pending is the count of background database defragmentation tasks that are currently pending.

  • Description
  • A textual description of the statistic or metric.

  • Frequency_Object
  • Not applicable.

  • Frequency_PerfTime
  • Not applicable.

  • Frequency_Sys100NS
  • Not applicable.

  • IODatabaseReadsAverageLatency
  • I/O Database Reads Average Latency is the average length of time, in milliseconds, per database read operation.

  • IODatabaseReadsPersec
  • I/O Database Reads/sec is the rate of database read operations completed.

  • IODatabaseWritesAverageLatency
  • I/O Database Writes Average Latency is the average length of time, in milliseconds, per database write operation.

  • IODatabaseWritesPersec
  • I/O Database Writes/sec is the rate of database write operations completed.

  • IOLogReadsPersec
  • I/O Log Reads/sec is the rate of logfile read operations completed.

  • IOLogWritesAverageLatency
  • I/O Log Writes Average Latency is the average length of time, in milliseconds, per logfile write operation.

  • IOLogWritesPersec
  • I/O Log Writes/sec is the rate of logfile write operations completed.

  • LogBytesGeneratedPersec
  • Log Bytes Generated per second is the rate at which data is added to the log. This is different from Log Bytes Write per second in that each byte is generated only once whereas each byte may be written many times.

  • LogBytesWritePersec
  • Log Bytes Write per second is the rate bytes are written to the log.

  • LogRecordStallsPersec
  • Log Record Stalls/sec is the number of log records that cannot be added to the log buffers per second because they are full. If this counter is non-zero most of the time, the log buffer size may be a bottleneck.

  • LogThreadsWaiting
  • Log Threads Waiting is the number of threads waiting for their data to be written to the log in order to complete an update of the database. If this number is too high, the log may be a bottleneck.

  • LogWritesPersec
  • Log Writes/sec is the number of times 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.

  • Name
  • The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property.

  • PagesConverted
  • Pages Converted is the count of database pages that have been converted from an older format

  • PagesConvertedPersec
  • Pages Converted/sec is the count of times per second a database page is converted from an older database format

  • RecordsConverted
  • Records Converted is the count of database records that have been converted from an older format

  • RecordsConvertedPersec
  • Records Converted/sec is the count of times per second a database record is converted from an older database format

  • SessionsInUse
  • Sessions In Use is the number of database sessions currently open for use by client threads.

  • SessionsPercentUsed
  • Sessions % Used is the percentage of database sessions currently open for use by client threads.

  • TableOpenCacheHitsPersec
  • Table Open Cache Hits/sec is 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.

  • TableOpenCacheMissesPersec
  • Table Open Cache Misses/sec is 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.

  • TableOpenCachePercentHit
  • Table Open Cache % Hit is the percentage of database tables opened using cached schema information. If this percentage is too low, the table cache size may be too small.

  • TableOpensPersec
  • Table Opens/sec is the number of database tables opened per second.

  • Timestamp_Object
  • Not applicable.

  • Timestamp_PerfTime
  • Not applicable.

  • Timestamp_Sys100NS
  • Not applicable.

  • Versionbucketsallocated
  • Total number of version buckets allocated


    Methods

    Method not found.

    Example WQL

    SELECT * FROM Win32_PerfFormattedData_ESENT_Database
    About this site information

    This contents is created by WMI having class information.
    WMI Environment is Windows Server 2008 R2 Enterprise Edition.

    This link is Microsoft documents for "Managing Windows with WMI".
    That is VB(Visual Basic) scripting sample.
    This link is Microsoft documents for "Advanced Programming Topics in WMI .NET".
    That is VB.net(Visual Basic .net) scripting sample.

    - WMI Library -
    http://library.wmifun.net/

    WMI useful by VB,VB.Net,VC,VC.Net,VC#.Net,VBS(WSH),PowerShell for PC asset management, system monitoring and collecting hardware and software inventory.

    This website is created by Toh.
    Copyright(C) 1997-2016 WMI Fun !!. All rights reserved.
    ^ Go to the top...