Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases, ROOT\cimv2 - Instances

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

Instances of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases

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

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_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' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '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' : '1' //String, 0x1
   'LogPoolDiskReadsPersec' : '2' //String, 0x2
   'LogPoolRequestsPersec' : '2' //String, 0x2
   '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' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243056417992' //String
   'Timestamp_Sys100NS' : '130603634063030000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '19' //String, 0x13
   'WriteTransactionsPersec' : '16' //String, 0x10
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_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' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LogBytesFlushedPersec' : '3072' //String, 0xC00
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '504' //String, 0x1F8
   'LogFilesUsedSizeKB' : '449' //String, 0x1C1
   'LogFlushesPersec' : '6' //String, 0x6
   'LogFlushWaitsPersec' : '6' //String, 0x6
   'LogFlushWaitTime' : '32' //String, 0x20
   'LogFlushWriteTimems' : '238' //String, 0xEE
   'LogGrowths' : '0' //String, 0x0
   'LogPoolCacheMissesPersec' : '1' //String, 0x1
   'LogPoolDiskReadsPersec' : '2' //String, 0x2
   'LogPoolRequestsPersec' : '6' //String, 0x6
   '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' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243056417992' //String
   'Timestamp_Sys100NS' : '130603634063030000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '5' //String, 0x5
   'WriteTransactionsPersec' : '1' //String, 0x1
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_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' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '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' : '1' //String, 0x1
   'LogPoolDiskReadsPersec' : '2' //String, 0x2
   'LogPoolRequestsPersec' : '6' //String, 0x6
   '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' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243056417992' //String
   'Timestamp_Sys100NS' : '130603634063030000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '3' //String, 0x3
   'WriteTransactionsPersec' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_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' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LogBytesFlushedPersec' : '1536' //String, 0x600
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '504' //String, 0x1F8
   'LogFilesUsedSizeKB' : '442' //String, 0x1BA
   'LogFlushesPersec' : '3' //String, 0x3
   'LogFlushWaitsPersec' : '3' //String, 0x3
   'LogFlushWaitTime' : '16' //String, 0x10
   'LogFlushWriteTimems' : '160' //String, 0xA0
   'LogGrowths' : '0' //String, 0x0
   'LogPoolCacheMissesPersec' : '1' //String, 0x1
   'LogPoolDiskReadsPersec' : '2' //String, 0x2
   'LogPoolRequestsPersec' : '6' //String, 0x6
   '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' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243056417992' //String
   'Timestamp_Sys100NS' : '130603634063030000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '12' //String, 0xC
   'WriteTransactionsPersec' : '1' //String, 0x1
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_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' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LogBytesFlushedPersec' : '13824' //String, 0x3600
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '2768' //String, 0xAD0
   'LogFilesUsedSizeKB' : '2022' //String, 0x7E6
   'LogFlushesPersec' : '19' //String, 0x13
   'LogFlushWaitsPersec' : '19' //String, 0x13
   'LogFlushWaitTime' : '95' //String, 0x5F
   'LogFlushWriteTimems' : '956' //String, 0x3BC
   'LogGrowths' : '0' //String, 0x0
   'LogPoolCacheMissesPersec' : '5' //String, 0x5
   'LogPoolDiskReadsPersec' : '10' //String, 0xA
   'LogPoolRequestsPersec' : '26' //String, 0x1A
   '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' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243056417992' //String
   'Timestamp_Sys100NS' : '130603634063030000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '67' //String, 0x43
   'WriteTransactionsPersec' : '32' //String, 0x20
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_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' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LogBytesFlushedPersec' : '9216' //String, 0x2400
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '760' //String, 0x2F8
   'LogFilesUsedSizeKB' : '388' //String, 0x184
   'LogFlushesPersec' : '10' //String, 0xA
   'LogFlushWaitsPersec' : '10' //String, 0xA
   'LogFlushWaitTime' : '47' //String, 0x2F
   'LogFlushWriteTimems' : '558' //String, 0x22E
   'LogGrowths' : '0' //String, 0x0
   'LogPoolCacheMissesPersec' : '1' //String, 0x1
   'LogPoolDiskReadsPersec' : '2' //String, 0x2
   'LogPoolRequestsPersec' : '6' //String, 0x6
   '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' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243056417992' //String
   'Timestamp_Sys100NS' : '130603634063030000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '28' //String, 0x1C
   'WriteTransactionsPersec' : '14' //String, 0xE
}
comments powered by Disqus
WUtils.com