Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases, ROOT\cimv2 - Instances

Class | Methods | Properties (38) | Qualifiers (14) | Instances (6) | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Instances of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases

This section contains sample wmi instances of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases class with their properties from Microsoft Windows Server 2012 R2 Datacenter Evaluation.

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases.Name="_Total"

Properties={
   'ActiveTransactions' : '0' //String, 0x0
   'BackupPerRestoreThroughputPersec' : '0' //String, 0x0
   'BulkCopyRowsPersec' : '0' //String, 0x0
   'BulkCopyThroughputPersec' : '0' //String, 0x0
   'Caption' : null
   'Committableentries' : '0' //String, 0x0
   'DataFilesSizeKB' : '62080' //String, 0xF280
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '2768' //String, 0xAD0
   'LogFilesUsedSizeKB' : '2022' //String, 0x7E6
   'LogFlushesPersec' : '0' //String, 0x0
   'LogFlushWaitsPersec' : '0' //String, 0x0
   'LogFlushWaitTime' : '95' //String, 0x5F
   'LogFlushWriteTimems' : '0' //String, 0x0
   'LogGrowths' : '0' //String, 0x0
   'LogPoolCacheMissesPersec' : '0' //String, 0x0
   'LogPoolDiskReadsPersec' : '0' //String, 0x0
   'LogPoolRequestsPersec' : '0' //String, 0x0
   'LogShrinks' : '0' //String, 0x0
   'LogTruncations' : '3' //String, 0x3
   'Name' : '_Total' //String
   'PercentLogUsed' : '73' //String, 0x49
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : null
   'Timestamp_PerfTime' : null
   'Timestamp_Sys100NS' : null
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '0' //String, 0x0
   'WriteTransactionsPersec' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases.Name="master"

Properties={
   'ActiveTransactions' : '0' //String, 0x0
   'BackupPerRestoreThroughputPersec' : '0' //String, 0x0
   'BulkCopyRowsPersec' : '0' //String, 0x0
   'BulkCopyThroughputPersec' : '0' //String, 0x0
   'Caption' : null
   'Committableentries' : '0' //String, 0x0
   'DataFilesSizeKB' : '4096' //String, 0x1000
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '760' //String, 0x2F8
   'LogFilesUsedSizeKB' : '388' //String, 0x184
   'LogFlushesPersec' : '0' //String, 0x0
   'LogFlushWaitsPersec' : '0' //String, 0x0
   'LogFlushWaitTime' : '47' //String, 0x2F
   'LogFlushWriteTimems' : '0' //String, 0x0
   'LogGrowths' : '0' //String, 0x0
   'LogPoolCacheMissesPersec' : '0' //String, 0x0
   'LogPoolDiskReadsPersec' : '0' //String, 0x0
   'LogPoolRequestsPersec' : '0' //String, 0x0
   'LogShrinks' : '0' //String, 0x0
   'LogTruncations' : '0' //String, 0x0
   'Name' : 'master' //String
   'PercentLogUsed' : '51' //String, 0x33
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : null
   'Timestamp_PerfTime' : null
   'Timestamp_Sys100NS' : null
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '0' //String, 0x0
   'WriteTransactionsPersec' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases.Name="model"

Properties={
   'ActiveTransactions' : '0' //String, 0x0
   'BackupPerRestoreThroughputPersec' : '0' //String, 0x0
   'BulkCopyRowsPersec' : '0' //String, 0x0
   'BulkCopyThroughputPersec' : '0' //String, 0x0
   'Caption' : null
   'Committableentries' : '0' //String, 0x0
   'DataFilesSizeKB' : '2112' //String, 0x840
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '504' //String, 0x1F8
   'LogFilesUsedSizeKB' : '449' //String, 0x1C1
   'LogFlushesPersec' : '0' //String, 0x0
   'LogFlushWaitsPersec' : '0' //String, 0x0
   'LogFlushWaitTime' : '32' //String, 0x20
   'LogFlushWriteTimems' : '0' //String, 0x0
   'LogGrowths' : '0' //String, 0x0
   'LogPoolCacheMissesPersec' : '0' //String, 0x0
   'LogPoolDiskReadsPersec' : '0' //String, 0x0
   'LogPoolRequestsPersec' : '0' //String, 0x0
   'LogShrinks' : '0' //String, 0x0
   'LogTruncations' : '2' //String, 0x2
   'Name' : 'model' //String
   'PercentLogUsed' : '89' //String, 0x59
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : null
   'Timestamp_PerfTime' : null
   'Timestamp_Sys100NS' : null
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '0' //String, 0x0
   'WriteTransactionsPersec' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases.Name="msdb"

Properties={
   'ActiveTransactions' : '0' //String, 0x0
   'BackupPerRestoreThroughputPersec' : '0' //String, 0x0
   'BulkCopyRowsPersec' : '0' //String, 0x0
   'BulkCopyThroughputPersec' : '0' //String, 0x0
   'Caption' : null
   'Committableentries' : '0' //String, 0x0
   'DataFilesSizeKB' : '12800' //String, 0x3200
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '504' //String, 0x1F8
   'LogFilesUsedSizeKB' : '442' //String, 0x1BA
   'LogFlushesPersec' : '0' //String, 0x0
   'LogFlushWaitsPersec' : '0' //String, 0x0
   'LogFlushWaitTime' : '16' //String, 0x10
   'LogFlushWriteTimems' : '0' //String, 0x0
   'LogGrowths' : '0' //String, 0x0
   'LogPoolCacheMissesPersec' : '0' //String, 0x0
   'LogPoolDiskReadsPersec' : '0' //String, 0x0
   'LogPoolRequestsPersec' : '0' //String, 0x0
   'LogShrinks' : '0' //String, 0x0
   'LogTruncations' : '1' //String, 0x1
   'Name' : 'msdb' //String
   'PercentLogUsed' : '87' //String, 0x57
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : null
   'Timestamp_PerfTime' : null
   'Timestamp_Sys100NS' : null
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '0' //String, 0x0
   'WriteTransactionsPersec' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases.Name="mssqlsystemresource"

Properties={
   'ActiveTransactions' : '0' //String, 0x0
   'BackupPerRestoreThroughputPersec' : '0' //String, 0x0
   'BulkCopyRowsPersec' : '0' //String, 0x0
   'BulkCopyThroughputPersec' : '0' //String, 0x0
   'Caption' : null
   'Committableentries' : '0' //String, 0x0
   'DataFilesSizeKB' : '40960' //String, 0xA000
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '504' //String, 0x1F8
   'LogFilesUsedSizeKB' : '399' //String, 0x18F
   'LogFlushesPersec' : '0' //String, 0x0
   'LogFlushWaitsPersec' : '0' //String, 0x0
   'LogFlushWaitTime' : '0' //String, 0x0
   'LogFlushWriteTimems' : '0' //String, 0x0
   'LogGrowths' : '0' //String, 0x0
   'LogPoolCacheMissesPersec' : '0' //String, 0x0
   'LogPoolDiskReadsPersec' : '0' //String, 0x0
   'LogPoolRequestsPersec' : '0' //String, 0x0
   'LogShrinks' : '0' //String, 0x0
   'LogTruncations' : '0' //String, 0x0
   'Name' : 'mssqlsystemresource' //String
   'PercentLogUsed' : '79' //String, 0x4F
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : null
   'Timestamp_PerfTime' : null
   'Timestamp_Sys100NS' : null
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '0' //String, 0x0
   'WriteTransactionsPersec' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases.Name="tempdb"

Properties={
   'ActiveTransactions' : '0' //String, 0x0
   'BackupPerRestoreThroughputPersec' : '0' //String, 0x0
   'BulkCopyRowsPersec' : '0' //String, 0x0
   'BulkCopyThroughputPersec' : '0' //String, 0x0
   'Caption' : null
   'Committableentries' : '0' //String, 0x0
   'DataFilesSizeKB' : '2112' //String, 0x840
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '496' //String, 0x1F0
   'LogFilesUsedSizeKB' : '344' //String, 0x158
   'LogFlushesPersec' : '0' //String, 0x0
   'LogFlushWaitsPersec' : '0' //String, 0x0
   'LogFlushWaitTime' : '0' //String, 0x0
   'LogFlushWriteTimems' : '0' //String, 0x0
   'LogGrowths' : '0' //String, 0x0
   'LogPoolCacheMissesPersec' : '0' //String, 0x0
   'LogPoolDiskReadsPersec' : '0' //String, 0x0
   'LogPoolRequestsPersec' : '0' //String, 0x0
   'LogShrinks' : '0' //String, 0x0
   'LogTruncations' : '0' //String, 0x0
   'Name' : 'tempdb' //String
   'PercentLogUsed' : '69' //String, 0x45
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : null
   'Timestamp_PerfTime' : null
   'Timestamp_Sys100NS' : null
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '0' //String, 0x0
   'WriteTransactionsPersec' : '0' //String, 0x0
}
comments powered by Disqus
WUtils.com