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("")