WUtils.com

Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabases, ROOT\cimv2 - Instances

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

Instances of Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabases

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

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_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' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '9616' //String, 0x2590
   'LogFilesUsedSizeKB' : '3446' //String, 0xD76
   'LogFlushesPersec' : '0' //String, 0x0
   'LogFlushWaitsPersec' : '0' //String, 0x0
   'LogFlushWaitTime' : '0' //String, 0x0
   'LogFlushWriteTimems' : '0' //String, 0x0
   'LogGrowths' : '1' //String, 0x1
   'LogPoolCacheMissesPersec' : '0' //String, 0x0
   'LogPoolDiskReadsPersec' : '0' //String, 0x0
   'LogPoolRequestsPersec' : '0' //String, 0x0
   'LogShrinks' : '0' //String, 0x0
   'LogTruncations' : '145' //String, 0x91
   'Name' : '_Total' //String
   'PercentLogUsed' : '35' //String, 0x23
   '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
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_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' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '2040' //String, 0x7F8
   'LogFilesUsedSizeKB' : '856' //String, 0x358
   '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' : 'master' //String
   'PercentLogUsed' : '42' //String, 0x2A
   '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
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_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' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '504' //String, 0x1F8
   'LogFilesUsedSizeKB' : '441' //String, 0x1B9
   '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' : '2' //String, 0x2
   'Name' : 'model' //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
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_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' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '760' //String, 0x2F8
   'LogFilesUsedSizeKB' : '396' //String, 0x18C
   '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' : 'msdb' //String
   'PercentLogUsed' : '52' //String, 0x34
   '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
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_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' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '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' : '0' //String, 0x0
   'LogPoolDiskReadsPersec' : '0' //String, 0x0
   'LogPoolRequestsPersec' : '0' //String, 0x0
   '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' : null
   'Timestamp_PerfTime' : null
   'Timestamp_Sys100NS' : null
   'TrackedtransactionsPersec' : '0' //String, 0x0
   'TransactionsPersec' : '0' //String, 0x0
   'WriteTransactionsPersec' : '0' //String, 0x0
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_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' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '4280' //String, 0x10B8
   'LogFilesUsedSizeKB' : '912' //String, 0x390
   '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' : 'ReportServer' //String
   'PercentLogUsed' : '21' //String, 0x15
   '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
   'XTPMemoryUsedKB' : '0' //String, 0x0
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfFormattedData_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' : null
   'Frequency_PerfTime' : null
   'Frequency_Sys100NS' : null
   'GroupCommitTimePersec' : '0' //String, 0x0
   'LogBytesFlushedPersec' : '0' //String, 0x0
   'LogCacheHitRatio' : '0' //String, 0x0
   'LogCacheReadsPersec' : '0' //String, 0x0
   'LogFilesSizeKB' : '760' //String, 0x2F8
   'LogFilesUsedSizeKB' : '403' //String, 0x193
   'LogFlushesPersec' : '0' //String, 0x0
   'LogFlushWaitsPersec' : '0' //String, 0x0
   'LogFlushWaitTime' : '0' //String, 0x0
   'LogFlushWriteTimems' : '0' //String, 0x0
   'LogGrowths' : '1' //String, 0x1
   'LogPoolCacheMissesPersec' : '0' //String, 0x0
   'LogPoolDiskReadsPersec' : '0' //String, 0x0
   'LogPoolRequestsPersec' : '0' //String, 0x0
   'LogShrinks' : '0' //String, 0x0
   'LogTruncations' : '143' //String, 0x8F
   'Name' : 'tempdb' //String
   'PercentLogUsed' : '53' //String, 0x35
   '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
   'XTPMemoryUsedKB' : '0' //String, 0x0
}
comments powered by Disqus
WUtils.com