WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases, ROOT\CIMV2

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

Description

This defines a Database manager object for SQL Server

Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases properties

Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases has 41 properties (32 Local, 9 Derived)

NameOriginCIMType
ActiveTransactionsWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
BackupPerRestoreThroughputPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
BulkCopyRowsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
BulkCopyThroughputPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CommittableentriesWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
DataFilesSizeKBWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
DBCCLogicalScanBytesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
GroupCommitTimePersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogBytesFlushedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogCacheHitRatioWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogCacheHitRatio_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogCacheReadsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogFilesSizeKBWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogFilesUsedSizeKBWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogFlushesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogFlushWaitsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogFlushWaitTimeWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogFlushWriteTimemsWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogGrowthsWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogPoolCacheMissesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogPoolDiskReadsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogPoolRequestsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogShrinksWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
LogTruncationsWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
PercentLogUsedWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
ReplPendingXactsWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
ReplTransRateWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
ShrinkDataMovementBytesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TrackedtransactionsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
TransactionsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
WriteTransactionsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]
XTPMemoryUsedKBWin32_PerfRawData_MSSQLSERVER_SQLServerDatabases21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases properties

Local properties (32) of Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases class

…
▲ ActiveTransactions property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of active update transactions for the database.'
DetailLevel100
DisplayName'Active Transactions'
DisplayName009'Active Transactions'
HelpIndex0
PerfIndex0
ActiveTransactions property is in 6 classes of ROOT\cimv2 and in 1 namespace
…
▲ BackupPerRestoreThroughputPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-6
Description'Read/write throughput for backup/restore of a database.'
DetailLevel100
DisplayName'Backup/Restore Throughput/sec'
DisplayName009'Backup/Restore Throughput/sec'
HelpIndex0
PerfIndex0
BackupPerRestoreThroughputPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ BulkCopyRowsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-3
Description'Number of rows bulk copied.'
DetailLevel100
DisplayName'Bulk Copy Rows/sec'
DisplayName009'Bulk Copy Rows/sec'
HelpIndex0
PerfIndex0
BulkCopyRowsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ BulkCopyThroughputPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'KiloBytes bulk copied.'
DetailLevel100
DisplayName'Bulk Copy Throughput/sec'
DisplayName009'Bulk Copy Throughput/sec'
HelpIndex0
PerfIndex0
BulkCopyThroughputPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Committableentries property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'The size of the in-memory part of the commit table for the database.'
DetailLevel100
DisplayName'Commit table entries'
DisplayName009'Commit table entries'
HelpIndex0
PerfIndex0
Committableentries property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ DataFilesSizeKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'The cumulative size of all the data files in the database.'
DetailLevel100
DisplayName'Data File(s) Size (KB)'
DisplayName009'Data File(s) Size (KB)'
HelpIndex0
PerfDefaultTrue
PerfIndex0
DataFilesSizeKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ DBCCLogicalScanBytesPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-5
Description'Logical read scan rate for DBCC commands'
DetailLevel100
DisplayName'DBCC Logical Scan Bytes/sec'
DisplayName009'DBCC Logical Scan Bytes/sec'
HelpIndex0
PerfIndex0
DBCCLogicalScanBytesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ GroupCommitTimePersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-6
Description'Group stall time (microseconds) per second.'
DetailLevel100
DisplayName'Group Commit Time/sec'
DisplayName009'Group Commit Time/sec'
HelpIndex0
PerfIndex0
GroupCommitTimePersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogBytesFlushedPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-4
Description'Total number of log bytes flushed.'
DetailLevel100
DisplayName'Log Bytes Flushed/sec'
DisplayName009'Log Bytes Flushed/sec'
HelpIndex0
PerfIndex0
LogBytesFlushedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogCacheHitRatio property
CIMTYPE'uint64'
CounterType537003264
DefaultScale0
Description'Percentage of log cache reads that were satisfied from the log cache.'
DetailLevel100
DisplayName'Log Cache Hit Ratio'
DisplayName009'Log Cache Hit Ratio'
HelpIndex0
PerfIndex0
LogCacheHitRatio property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogCacheHitRatio_Base property
CIMTYPE'uint64'
CounterType1073939712
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
LogCacheHitRatio_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogCacheReadsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-1
Description'Reads performed through the log manager cache.'
DetailLevel100
DisplayName'Log Cache Reads/sec'
DisplayName009'Log Cache Reads/sec'
HelpIndex0
PerfIndex0
LogCacheReadsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogFilesSizeKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'The cumulative size of all the log files in the database.'
DetailLevel100
DisplayName'Log File(s) Size (KB)'
DisplayName009'Log File(s) Size (KB)'
HelpIndex0
PerfIndex0
LogFilesSizeKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogFilesUsedSizeKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'The cumulative used size of all the log files in the database.'
DetailLevel100
DisplayName'Log File(s) Used Size (KB)'
DisplayName009'Log File(s) Used Size (KB)'
HelpIndex0
PerfIndex0
LogFilesUsedSizeKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogFlushesPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of log flushes.'
DetailLevel100
DisplayName'Log Flushes/sec'
DisplayName009'Log Flushes/sec'
HelpIndex0
PerfIndex0
LogFlushesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogFlushWaitsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of commits waiting on log flush.'
DetailLevel100
DisplayName'Log Flush Waits/sec'
DisplayName009'Log Flush Waits/sec'
HelpIndex0
PerfIndex0
LogFlushWaitsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogFlushWaitTime property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-3
Description'Total wait time (milliseconds).'
DetailLevel100
DisplayName'Log Flush Wait Time'
DisplayName009'Log Flush Wait Time'
HelpIndex0
PerfIndex0
LogFlushWaitTime property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogFlushWriteTimems property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Milliseconds it took to perform the writes of log flushes completed in the last second'
DetailLevel100
DisplayName'Log Flush Write Time (ms)'
DisplayName009'Log Flush Write Time (ms)'
HelpIndex0
PerfIndex0
LogFlushWriteTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogGrowths property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'Total number of log growths for this database.'
DetailLevel100
DisplayName'Log Growths'
DisplayName009'Log Growths'
HelpIndex0
PerfIndex0
LogGrowths property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogPoolCacheMissesPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-1
Description'Log block cache misses from log pool.'
DetailLevel100
DisplayName'Log Pool Cache Misses/sec'
DisplayName009'Log Pool Cache Misses/sec'
HelpIndex0
PerfIndex0
LogPoolCacheMissesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogPoolDiskReadsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-1
Description'Log disk reads via log pool.'
DetailLevel100
DisplayName'Log Pool Disk Reads/sec'
DisplayName009'Log Pool Disk Reads/sec'
HelpIndex0
PerfIndex0
LogPoolDiskReadsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogPoolRequestsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-1
Description'Log block requests performed through log pool.'
DetailLevel100
DisplayName'Log Pool Requests/sec'
DisplayName009'Log Pool Requests/sec'
HelpIndex0
PerfIndex0
LogPoolRequestsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogShrinks property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'Total number of log shrinks for this database.'
DetailLevel100
DisplayName'Log Shrinks'
DisplayName009'Log Shrinks'
HelpIndex0
PerfIndex0
LogShrinks property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogTruncations property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'Total number of log truncations for this database.'
DetailLevel100
DisplayName'Log Truncations'
DisplayName009'Log Truncations'
HelpIndex0
PerfIndex0
LogTruncations property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ PercentLogUsed property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'The percent of space in the log that is in use.'
DetailLevel100
DisplayName'Percent Log Used'
DisplayName009'Percent Log Used'
HelpIndex0
PerfIndex0
PercentLogUsed property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ReplPendingXacts property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of pending replication transactions in the database.'
DetailLevel100
DisplayName'Repl. Pending Xacts'
DisplayName009'Repl. Pending Xacts'
HelpIndex0
PerfIndex0
ReplPendingXacts property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ReplTransRate property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Replication transaction rate (replicated transactions/sec.).'
DetailLevel100
DisplayName'Repl. Trans. Rate'
DisplayName009'Repl. Trans. Rate'
HelpIndex0
PerfIndex0
ReplTransRate property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ShrinkDataMovementBytesPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-4
Description'The rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE.'
DetailLevel100
DisplayName'Shrink Data Movement Bytes/sec'
DisplayName009'Shrink Data Movement Bytes/sec'
HelpIndex0
PerfIndex0
ShrinkDataMovementBytesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TrackedtransactionsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of committed transactions recorded in the commit table for the database.'
DetailLevel100
DisplayName'Tracked transactions/sec'
DisplayName009'Tracked transactions/sec'
HelpIndex0
PerfIndex0
TrackedtransactionsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TransactionsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of transactions started for the database.'
DetailLevel100
DisplayName'Transactions/sec'
DisplayName009'Transactions/sec'
HelpIndex0
PerfIndex0
TransactionsPersec property is in 16 classes of ROOT\cimv2 and in 1 namespace
…
▲ WriteTransactionsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of transactions which wrote to the database in the last second.'
DetailLevel100
DisplayName'Write Transactions/sec'
DisplayName009'Write Transactions/sec'
HelpIndex0
PerfIndex0
WriteTransactionsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ XTPMemoryUsedKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'The amount of memory used by XTP in the database.'
DetailLevel100
DisplayName'XTP Memory Used (KB)'
DisplayName009'XTP Memory Used (KB)'
HelpIndex0
PerfIndex0
XTPMemoryUsedKB property is in 2 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases class

…
▲ Caption property
CIMTYPE'string'
Description'A short textual description (one-line string) for the statistic or metric.'
MaxLen64
readTrue
Caption property is in 1050 classes of ROOT\cimv2 and in 37 namespaces
…
▲ Description property
CIMTYPE'string'
Description'A textual description of the statistic or metric.'
readTrue
Description property is in 1061 classes of ROOT\cimv2 and in 142 namespaces
…
▲ Frequency_Object property
CIMTYPE'uint64'
Frequency_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Frequency_PerfTime property
CIMTYPE'uint64'
Frequency_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Frequency_Sys100NS property
CIMTYPE'uint64'
Frequency_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Name property
CIMTYPE'string'
Description'The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property. '
keyTrue
MaxLen256
readTrue
Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
…
▲ Timestamp_Object property
CIMTYPE'uint64'
Timestamp_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Timestamp_PerfTime property
CIMTYPE'uint64'
Timestamp_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Timestamp_Sys100NS property
CIMTYPE'uint64'
Timestamp_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces

Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
Description'This defines a Database manager object for SQL Server'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'SQLServer:Databases'✓✗✓✓✓
DisplayName009'SQLServer:Databases'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓

Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases System properties

…
NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases'___SYSTEM8✗✗
__NAMESPACE'ROOT\cimv2'___SYSTEM8✗✗
__SERVER'.'___SYSTEM8✗✗
__DERIVATION['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8✗✓
__PROPERTY_COUNT41___SYSTEM3✗✗
__RELPATH'Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases'___SYSTEM8✗✗
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8✗✗
__SUPERCLASS'Win32_PerfRawData'___SYSTEM8✗✗
__CLASS'Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases'___SYSTEM8✗✗
__GENUS1___SYSTEM3✗✗

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases

Number of classes:1
…
Class nameChildsPropertiesMethodsClass
Instances		Child
Instances		AbstractSingleton
Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabases04007---
comments powered by Disqus
WUtils.com