WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases, ROOT\cimv2 - Instances

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

Instances of Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases

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

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases.Name="ReportServer"

Properties={
   'ActiveTransactions' : '0' //String, 0x0
   'BackupPerRestoreThroughputPersec' : '0' //String, 0x0
   'BulkCopyRowsPersec' : '0' //String, 0x0
   'BulkCopyThroughputPersec' : '0' //String, 0x0
   'Caption' : null
   'Committableentries' : '0' //String, 0x0
   'DataFilesSizeKB' : '4288' //String, 0x10C0
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '1536' //String, 0x600
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '4280' //String, 0x10B8
   'LogFilesUsedSizeKB' : '912' //String, 0x390
   'LogFlushesPersec' : '3' //String, 0x3
   'LogFlushWaitsPersec' : '2' //String, 0x2
   'LogFlushWaitTime' : '63' //String, 0x3F
   'LogFlushWriteTimems' : '86' //String, 0x56
   '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' : 'ReportServer' //String
   'PercentLogUsed' : '21' //String, 0x15
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243068566239' //String
   'Timestamp_Sys100NS' : '130603634107240000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '4718' //String, 0x126E
   'WriteTransactionsPersec' : '1' //String, 0x1
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases.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' : '2240' //String, 0x8C0
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '14409216' //String, 0xDBDE00
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '760' //String, 0x2F8
   'LogFilesUsedSizeKB' : '483' //String, 0x1E3
   'LogFlushesPersec' : '342' //String, 0x156
   'LogFlushWaitsPersec' : '114' //String, 0x72
   'LogFlushWaitTime' : '4529' //String, 0x11B1
   'LogFlushWriteTimems' : '16669' //String, 0x411D
   'LogGrowths' : '1' //String, 0x1
   'LogPoolCacheMissesPersec' : '1' //String, 0x1
   'LogPoolDiskReadsPersec' : '2' //String, 0x2
   'LogPoolRequestsPersec' : '2' //String, 0x2
   'LogShrinks' : '0' //String, 0x0
   'LogTruncations' : '143' //String, 0x8F
   'Name' : 'tempdb' //String
   'PercentLogUsed' : '63' //String, 0x3F
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243068566239' //String
   'Timestamp_Sys100NS' : '130603634107240000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '10649' //String, 0x2999
   'WriteTransactionsPersec' : '4036' //String, 0xFC4
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases.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' : '2240' //String, 0x8C0
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '3072' //String, 0xC00
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '504' //String, 0x1F8
   'LogFilesUsedSizeKB' : '441' //String, 0x1B9
   'LogFlushesPersec' : '6' //String, 0x6
   'LogFlushWaitsPersec' : '6' //String, 0x6
   'LogFlushWaitTime' : '177' //String, 0xB1
   'LogFlushWriteTimems' : '194' //String, 0xC2
   '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' : '87' //String, 0x57
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243068566239' //String
   'Timestamp_Sys100NS' : '130603634107240000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '298' //String, 0x12A
   'WriteTransactionsPersec' : '1' //String, 0x1
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases.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' : '14464' //String, 0x3880
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '1536' //String, 0x600
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '760' //String, 0x2F8
   'LogFilesUsedSizeKB' : '396' //String, 0x18C
   'LogFlushesPersec' : '3' //String, 0x3
   'LogFlushWaitsPersec' : '2' //String, 0x2
   'LogFlushWaitTime' : '75' //String, 0x4B
   'LogFlushWriteTimems' : '104' //String, 0x68
   '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' : 'msdb' //String
   'PercentLogUsed' : '52' //String, 0x34
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243068566239' //String
   'Timestamp_Sys100NS' : '130603634107240000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '312' //String, 0x138
   'WriteTransactionsPersec' : '1' //String, 0x1
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases.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
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '1272' //String, 0x4F8
   'LogFilesUsedSizeKB' : '438' //String, 0x1B6
   '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' : '34' //String, 0x22
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243068566239' //String
   'Timestamp_Sys100NS' : '130603634107240000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '289' //String, 0x121
   'WriteTransactionsPersec' : '0' //String, 0x0
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases.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' : '68288' //String, 0x10AC0
   'DBCCLogicalScanBytesPersec' : '0' //String, 0x0
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '15598592' //String, 0xEE0400
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '9616' //String, 0x2590
   'LogFilesUsedSizeKB' : '3528' //String, 0xDC8
   'LogFlushesPersec' : '2663' //String, 0xA67
   'LogFlushWaitsPersec' : '2261' //String, 0x8D5
   'LogFlushWaitTime' : '89676' //String, 0x15E4C
   'LogFlushWriteTimems' : '107332' //String, 0x1A344
   'LogGrowths' : '1' //String, 0x1
   'LogPoolCacheMissesPersec' : '407' //String, 0x197
   'LogPoolDiskReadsPersec' : '639' //String, 0x27F
   'LogPoolRequestsPersec' : '1742' //String, 0x6CE
   'LogShrinks' : '0' //String, 0x0
   'LogTruncations' : '145' //String, 0x91
   'Name' : '_Total' //String
   'PercentLogUsed' : '36' //String, 0x24
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243068566239' //String
   'Timestamp_Sys100NS' : '130603634107240000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '20787' //String, 0x5133
   'WriteTransactionsPersec' : '4899' //String, 0x1323
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases.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
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '296448' //String, 0x48600
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheHitRatio_Base' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '2040' //String, 0x7F8
   'LogFilesUsedSizeKB' : '858' //String, 0x35A
   'LogFlushesPersec' : '577' //String, 0x241
   'LogFlushWaitsPersec' : '575' //String, 0x23F
   'LogFlushWaitTime' : '36599' //String, 0x8EF7
   'LogFlushWriteTimems' : '36508' //String, 0x8E9C
   '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' : '42' //String, 0x2A
   'ReplPendingXacts' : '0' //String, 0x0
   'ReplTransRate' : '0' //String, 0x0
   'ShrinkDataMovementBytesPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243068566239' //String
   'Timestamp_Sys100NS' : '130603634107240000' //String
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '1739' //String, 0x6CB
   'WriteTransactionsPersec' : '575' //String, 0x23F
   'XTPMemoryUsedKB' : '0' //String, 0x0
}
comments powered by Disqus
WUtils.com