Win32_PerfRawData_ESENT python sample code

The foundations for Manageability in Windows is Windows Management Instrumentation (WMI; formerly WBEM) and WMI extensions for Windows Driver Model (WDM).

ActiveXperts Network Monitor provides the ability to build monitor check routines based on WMI. ActiveXperts has collected more than a hundred WMI samples. You can use these samples as a base for new check routines you can write yourself. The Win32_PerfRawData_ESENT WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

---

Sample Code

from win32com.client import GetObject
objWMI = GetObject('winmgmts:').InstancesOf('Win32_PerfRawData_ESENT_Database')

for obj in objWMI:
	if obj.Caption != None:
		print("Caption:" + str(obj.Caption))
	if obj.DatabaseCacheMemoryCommitted != None:
		print("DatabaseCacheMemoryCommitted:" + str(obj.DatabaseCacheMemoryCommitted))
	if obj.DatabaseCacheMemoryCommittedMB != None:
		print("DatabaseCacheMemoryCommittedMB:" + str(obj.DatabaseCacheMemoryCommittedMB))
	if obj.DatabaseCacheMemoryReserved != None:
		print("DatabaseCacheMemoryReserved:" + str(obj.DatabaseCacheMemoryReserved))
	if obj.DatabaseCacheMemoryReservedMB != None:
		print("DatabaseCacheMemoryReservedMB:" + str(obj.DatabaseCacheMemoryReservedMB))
	if obj.DatabaseCacheMissesPersec != None:
		print("DatabaseCacheMissesPersec:" + str(obj.DatabaseCacheMissesPersec))
	if obj.DatabaseCachePercentDehydrated != None:
		print("DatabaseCachePercentDehydrated:" + str(obj.DatabaseCachePercentDehydrated))
	if obj.DatabaseCachePercentDehydrated_Base != None:
		print("DatabaseCachePercentDehydrated_Base:" + str(obj.DatabaseCachePercentDehydrated_Base))
	if obj.DatabaseCachePercentHit != None:
		print("DatabaseCachePercentHit:" + str(obj.DatabaseCachePercentHit))
	if obj.DatabaseCachePercentHit_Base != None:
		print("DatabaseCachePercentHit_Base:" + str(obj.DatabaseCachePercentHit_Base))
	if obj.DatabaseCachePercentHitUncorrelated != None:
		print("DatabaseCachePercentHitUncorrelated:" + str(obj.DatabaseCachePercentHitUncorrelated))
	if obj.DatabaseCachePercentHitUncorrelated_Base != None:
		print("DatabaseCachePercentHitUncorrelated_Base:" + str(obj.DatabaseCachePercentHitUncorrelated_Base))
	if obj.DatabaseCacheRequestsPersec != None:
		print("DatabaseCacheRequestsPersec:" + str(obj.DatabaseCacheRequestsPersec))
	if obj.DatabaseCacheSize != None:
		print("DatabaseCacheSize:" + str(obj.DatabaseCacheSize))
	if obj.DatabaseCacheSizeEffective != None:
		print("DatabaseCacheSizeEffective:" + str(obj.DatabaseCacheSizeEffective))
	if obj.DatabaseCacheSizeEffectiveMB != None:
		print("DatabaseCacheSizeEffectiveMB:" + str(obj.DatabaseCacheSizeEffectiveMB))
	if obj.DatabaseCacheSizeMB != None:
		print("DatabaseCacheSizeMB:" + str(obj.DatabaseCacheSizeMB))
	if obj.DatabaseCacheSizeResident != None:
		print("DatabaseCacheSizeResident:" + str(obj.DatabaseCacheSizeResident))
	if obj.DatabaseCacheSizeResidentMB != None:
		print("DatabaseCacheSizeResidentMB:" + str(obj.DatabaseCacheSizeResidentMB))
	if obj.DatabaseMaintenanceDuration != None:
		print("DatabaseMaintenanceDuration:" + str(obj.DatabaseMaintenanceDuration))
	if obj.DatabaseMaintenancePagesBadChecksums != None:
		print("DatabaseMaintenancePagesBadChecksums:" + str(obj.DatabaseMaintenancePagesBadChecksums))
	if obj.DatabasePageEvictionsPersec != None:
		print("DatabasePageEvictionsPersec:" + str(obj.DatabasePageEvictionsPersec))
	if obj.DatabasePageFaultsPersec != None:
		print("DatabasePageFaultsPersec:" + str(obj.DatabasePageFaultsPersec))
	if obj.DatabasePageFaultStallsPersec != None:
		print("DatabasePageFaultStallsPersec:" + str(obj.DatabasePageFaultStallsPersec))
	if obj.DefragmentationTasks != None:
		print("DefragmentationTasks:" + str(obj.DefragmentationTasks))
	if obj.DefragmentationTasksPending != None:
		print("DefragmentationTasksPending:" + str(obj.DefragmentationTasksPending))
	if obj.Description != None:
		print("Description:" + str(obj.Description))
	if obj.Frequency_Object != None:
		print("Frequency_Object:" + str(obj.Frequency_Object))
	if obj.Frequency_PerfTime != None:
		print("Frequency_PerfTime:" + str(obj.Frequency_PerfTime))
	if obj.Frequency_Sys100NS != None:
		print("Frequency_Sys100NS:" + str(obj.Frequency_Sys100NS))
	if obj.IODatabaseReadsAttachedAverageLatency != None:
		print("IODatabaseReadsAttachedAverageLatency:" + str(obj.IODatabaseReadsAttachedAverageLatency))
	if obj.IODatabaseReadsAttachedAverageLatency_Base != None:
		print("IODatabaseReadsAttachedAverageLatency_Base:" + str(obj.IODatabaseReadsAttachedAverageLatency_Base))
	if obj.IODatabaseReadsAttachedPersec != None:
		print("IODatabaseReadsAttachedPersec:" + str(obj.IODatabaseReadsAttachedPersec))
	if obj.IODatabaseReadsAverageLatency != None:
		print("IODatabaseReadsAverageLatency:" + str(obj.IODatabaseReadsAverageLatency))
	if obj.IODatabaseReadsAverageLatency_Base != None:
		print("IODatabaseReadsAverageLatency_Base:" + str(obj.IODatabaseReadsAverageLatency_Base))
	if obj.IODatabaseReadsPersec != None:
		print("IODatabaseReadsPersec:" + str(obj.IODatabaseReadsPersec))
	if obj.IODatabaseReadsRecoveryAverageLatency != None:
		print("IODatabaseReadsRecoveryAverageLatency:" + str(obj.IODatabaseReadsRecoveryAverageLatency))
	if obj.IODatabaseReadsRecoveryAverageLatency_Base != None:
		print("IODatabaseReadsRecoveryAverageLatency_Base:" + str(obj.IODatabaseReadsRecoveryAverageLatency_Base))
	if obj.IODatabaseReadsRecoveryPersec != None:
		print("IODatabaseReadsRecoveryPersec:" + str(obj.IODatabaseReadsRecoveryPersec))
	if obj.IODatabaseWritesAttachedAverageLatency != None:
		print("IODatabaseWritesAttachedAverageLatency:" + str(obj.IODatabaseWritesAttachedAverageLatency))
	if obj.IODatabaseWritesAttachedAverageLatency_Base != None:
		print("IODatabaseWritesAttachedAverageLatency_Base:" + str(obj.IODatabaseWritesAttachedAverageLatency_Base))
	if obj.IODatabaseWritesAttachedPersec != None:
		print("IODatabaseWritesAttachedPersec:" + str(obj.IODatabaseWritesAttachedPersec))
	if obj.IODatabaseWritesAverageLatency != None:
		print("IODatabaseWritesAverageLatency:" + str(obj.IODatabaseWritesAverageLatency))
	if obj.IODatabaseWritesAverageLatency_Base != None:
		print("IODatabaseWritesAverageLatency_Base:" + str(obj.IODatabaseWritesAverageLatency_Base))
	if obj.IODatabaseWritesPersec != None:
		print("IODatabaseWritesPersec:" + str(obj.IODatabaseWritesPersec))
	if obj.IODatabaseWritesRecoveryAverageLatency != None:
		print("IODatabaseWritesRecoveryAverageLatency:" + str(obj.IODatabaseWritesRecoveryAverageLatency))
	if obj.IODatabaseWritesRecoveryAverageLatency_Base != None:
		print("IODatabaseWritesRecoveryAverageLatency_Base:" + str(obj.IODatabaseWritesRecoveryAverageLatency_Base))
	if obj.IODatabaseWritesRecoveryPersec != None:
		print("IODatabaseWritesRecoveryPersec:" + str(obj.IODatabaseWritesRecoveryPersec))
	if obj.IOLogReadsAverageLatency != None:
		print("IOLogReadsAverageLatency:" + str(obj.IOLogReadsAverageLatency))
	if obj.IOLogReadsAverageLatency_Base != None:
		print("IOLogReadsAverageLatency_Base:" + str(obj.IOLogReadsAverageLatency_Base))
	if obj.IOLogReadsPersec != None:
		print("IOLogReadsPersec:" + str(obj.IOLogReadsPersec))
	if obj.IOLogWritesAverageLatency != None:
		print("IOLogWritesAverageLatency:" + str(obj.IOLogWritesAverageLatency))
	if obj.IOLogWritesAverageLatency_Base != None:
		print("IOLogWritesAverageLatency_Base:" + str(obj.IOLogWritesAverageLatency_Base))
	if obj.IOLogWritesPersec != None:
		print("IOLogWritesPersec:" + str(obj.IOLogWritesPersec))
	if obj.LogBytesGeneratedPersec != None:
		print("LogBytesGeneratedPersec:" + str(obj.LogBytesGeneratedPersec))
	if obj.LogBytesWritePersec != None:
		print("LogBytesWritePersec:" + str(obj.LogBytesWritePersec))
	if obj.LogRecordStallsPersec != None:
		print("LogRecordStallsPersec:" + str(obj.LogRecordStallsPersec))
	if obj.LogThreadsWaiting != None:
		print("LogThreadsWaiting:" + str(obj.LogThreadsWaiting))
	if obj.LogWritesPersec != None:
		print("LogWritesPersec:" + str(obj.LogWritesPersec))
	if obj.Name != None:
		print("Name:" + str(obj.Name))
	if obj.SessionsInUse != None:
		print("SessionsInUse:" + str(obj.SessionsInUse))
	if obj.SessionsPercentUsed != None:
		print("SessionsPercentUsed:" + str(obj.SessionsPercentUsed))
	if obj.SessionsPercentUsed_Base != None:
		print("SessionsPercentUsed_Base:" + str(obj.SessionsPercentUsed_Base))
	if obj.TableClosesPersec != None:
		print("TableClosesPersec:" + str(obj.TableClosesPersec))
	if obj.TableOpenCacheHitsPersec != None:
		print("TableOpenCacheHitsPersec:" + str(obj.TableOpenCacheHitsPersec))
	if obj.TableOpenCacheMissesPersec != None:
		print("TableOpenCacheMissesPersec:" + str(obj.TableOpenCacheMissesPersec))
	if obj.TableOpenCachePercentHit != None:
		print("TableOpenCachePercentHit:" + str(obj.TableOpenCachePercentHit))
	if obj.TableOpenCachePercentHit_Base != None:
		print("TableOpenCachePercentHit_Base:" + str(obj.TableOpenCachePercentHit_Base))
	if obj.TableOpensPersec != None:
		print("TableOpensPersec:" + str(obj.TableOpensPersec))
	if obj.TablesOpen != None:
		print("TablesOpen:" + str(obj.TablesOpen))
	if obj.Timestamp_Object != None:
		print("Timestamp_Object:" + str(obj.Timestamp_Object))
	if obj.Timestamp_PerfTime != None:
		print("Timestamp_PerfTime:" + str(obj.Timestamp_PerfTime))
	if obj.Timestamp_Sys100NS != None:
		print("Timestamp_Sys100NS:" + str(obj.Timestamp_Sys100NS))
	if obj.VersionBucketsAllocated != None:
		print("VersionBucketsAllocated:" + str(obj.VersionBucketsAllocated))
	print("")
	print("########")
	print("")