Includes&Samples |
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabases, ROOT\cimv2 - InstancesClass | Methods | Properties (39) | Qualifiers (12) | Instances (6) | Namespaces (1)Samples: VB Script | C# | VB.Net | Search on:Microsoft Instances of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabasesThis 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 } |