DatabaseInstances - WMI sample in Python

The foundations for Manageability in Windows 2019/2012/2008/ and Windows 10/8/7/Vista/XP are 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.

On this site, you can find many WMI samples.

The DatabaseInstances WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

---

DatabaseInstances

Example(s)

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

for obj in objWMI:
	if obj.Caption != None:
		print("Caption:" + str(obj.Caption))
	if obj.DatabaseCacheMissesPersec != None:
		print("DatabaseCacheMissesPersec:" + str(obj.DatabaseCacheMissesPersec))
	if obj.DatabaseCachePercentHit != None:
		print("DatabaseCachePercentHit:" + str(obj.DatabaseCachePercentHit))
	if obj.DatabaseCachePercentHitUncorrelated != None:
		print("DatabaseCachePercentHitUncorrelated:" + str(obj.DatabaseCachePercentHitUncorrelated))
	if obj.DatabaseCacheRequestsPersec != None:
		print("DatabaseCacheRequestsPersec:" + str(obj.DatabaseCacheRequestsPersec))
	if obj.DatabaseCacheSizeMB != None:
		print("DatabaseCacheSizeMB:" + str(obj.DatabaseCacheSizeMB))
	if obj.DatabaseMaintenanceDuration != None:
		print("DatabaseMaintenanceDuration:" + str(obj.DatabaseMaintenanceDuration))
	if obj.DatabaseMaintenancePagesBadChecksums != None:
		print("DatabaseMaintenancePagesBadChecksums:" + str(obj.DatabaseMaintenancePagesBadChecksums))
	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.IODatabaseReadsAttachedPersec != None:
		print("IODatabaseReadsAttachedPersec:" + str(obj.IODatabaseReadsAttachedPersec))
	if obj.IODatabaseReadsAverageLatency != None:
		print("IODatabaseReadsAverageLatency:" + str(obj.IODatabaseReadsAverageLatency))
	if obj.IODatabaseReadsPersec != None:
		print("IODatabaseReadsPersec:" + str(obj.IODatabaseReadsPersec))
	if obj.IODatabaseReadsRecoveryAverageLatency != None:
		print("IODatabaseReadsRecoveryAverageLatency:" + str(obj.IODatabaseReadsRecoveryAverageLatency))
	if obj.IODatabaseReadsRecoveryPersec != None:
		print("IODatabaseReadsRecoveryPersec:" + str(obj.IODatabaseReadsRecoveryPersec))
	if obj.IODatabaseWritesAttachedAverageLatency != None:
		print("IODatabaseWritesAttachedAverageLatency:" + str(obj.IODatabaseWritesAttachedAverageLatency))
	if obj.IODatabaseWritesAttachedPersec != None:
		print("IODatabaseWritesAttachedPersec:" + str(obj.IODatabaseWritesAttachedPersec))
	if obj.IODatabaseWritesAverageLatency != None:
		print("IODatabaseWritesAverageLatency:" + str(obj.IODatabaseWritesAverageLatency))
	if obj.IODatabaseWritesPersec != None:
		print("IODatabaseWritesPersec:" + str(obj.IODatabaseWritesPersec))
	if obj.IODatabaseWritesRecoveryAverageLatency != None:
		print("IODatabaseWritesRecoveryAverageLatency:" + str(obj.IODatabaseWritesRecoveryAverageLatency))
	if obj.IODatabaseWritesRecoveryPersec != None:
		print("IODatabaseWritesRecoveryPersec:" + str(obj.IODatabaseWritesRecoveryPersec))
	if obj.IOLogReadsAverageLatency != None:
		print("IOLogReadsAverageLatency:" + str(obj.IOLogReadsAverageLatency))
	if obj.IOLogReadsPersec != None:
		print("IOLogReadsPersec:" + str(obj.IOLogReadsPersec))
	if obj.IOLogWritesAverageLatency != None:
		print("IOLogWritesAverageLatency:" + str(obj.IOLogWritesAverageLatency))
	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.LogCheckpointDepthasaPercentofTarget != None:
		print("LogCheckpointDepthasaPercentofTarget:" + str(obj.LogCheckpointDepthasaPercentofTarget))
	if obj.LogFileCurrentGeneration != None:
		print("LogFileCurrentGeneration:" + str(obj.LogFileCurrentGeneration))
	if obj.LogFilesGenerated != None:
		print("LogFilesGenerated:" + str(obj.LogFilesGenerated))
	if obj.LogFilesGeneratedPrematurely != None:
		print("LogFilesGeneratedPrematurely:" + str(obj.LogFilesGeneratedPrematurely))
	if obj.LogGenerationCheckpointDepth != None:
		print("LogGenerationCheckpointDepth:" + str(obj.LogGenerationCheckpointDepth))
	if obj.LogGenerationCheckpointDepthMax != None:
		print("LogGenerationCheckpointDepthMax:" + str(obj.LogGenerationCheckpointDepthMax))
	if obj.LogGenerationCheckpointDepthTarget != None:
		print("LogGenerationCheckpointDepthTarget:" + str(obj.LogGenerationCheckpointDepthTarget))
	if obj.LogGenerationLossResiliencyDepth != None:
		print("LogGenerationLossResiliencyDepth:" + str(obj.LogGenerationLossResiliencyDepth))
	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.StreamingBackupPagesReadPersec != None:
		print("StreamingBackupPagesReadPersec:" + str(obj.StreamingBackupPagesReadPersec))
	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.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("")