- WMI Library -
WMI Libraly > Win32_PerfRawData_ESENT_DatabaseInstances Class

Win32_PerfRawData_ESENT_DatabaseInstances Class

Instances in this process
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.

  • DatabaseCachePercentHit_Base


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

  • 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.

  • 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.

  • IODatabaseReadsAverageLatency_Base


  • 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.

  • IODatabaseWritesAverageLatency_Base


  • 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.

  • IOLogWritesAverageLatency_Base


  • 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.

  • LogCheckpointDepthasaPercentofTarget
  • Log Checkpoint Depth as a % of Target is an expression of the current checkpoint depth in terms of a percentage of the checkpoint depth target. For example, if the current checkpoint depth is 5 generations and the checkpoint depth target is 4 generations then this will be reported as 125% of target.

  • LogCheckpointDepthasaPercentofTarget_Base


  • LogFileCurrentGeneration
  • Log File Current Generation gives the generation number of the current log file of an instance.

  • LogFilesGenerated
  • Log Files Generated represents the total number of log files generated by an instance since that instance was last initialized.

  • LogFilesGeneratedPrematurely
  • Log Files Generated Prematurely represents the total number of log files generated by an instance since that instance was last initialized and that have not been entirely filled with useful data. Under certain conditions the database engine will choose to switch to a new log file before it has been completely filled with useful data.

  • LogGenerationCheckpointDepth
  • Log Generation Checkpoint Depth represents the amount of work, in count of log files, that will need to be redone or undone to the database file(s) if the process crashes.

  • LogGenerationCheckpointDepthMax
  • Log Generation Checkpoint Depth Max represents the maximum allowable amount of work, in count of log files, that may be redone or undone to the database file(s) if the process crashes.

  • LogGenerationCheckpointDepthTarget
  • Log Generation Checkpoint Depth Target represents the ideal target for the amount of work, in count of log files, that may be redone or undone to the database file(s) if the process crashes.

  • LogGenerationLossResiliencyDepth
  • Log Generation Loss Resiliency Depth represents the amount of work, in count of log files, that may be lost while still allowing the database file(s) to recover (with data loss) if the process crashes.

  • 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.

  • SessionsPercentUsed_Base


  • StreamingBackupPagesReadPersec
  • Streaming Backup Pages Read/sec is the rate of database read operations performed for the purpose of streaming backups.

  • 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.

  • TableOpenCachePercentHit_Base


  • 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_PerfRawData_ESENT_DatabaseInstances
    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...