| Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases |
| This defines a Database manager object for SQL Server |
| NameSpace Path |
| \ROOT\CIMV2 |
| PROPERTY | SMS_REPORT | CIMTYPE | DESCRIPTION |
| ActiveTransactions | | UInt64 | Number of active update transactions for the database. |
| BackupPerRestoreThroughputPersec | | UInt64 | Read/write throughput for backup/restore of a database. |
| BulkCopyRowsPersec | | UInt64 | Number of rows bulk copied. |
| BulkCopyThroughputPersec | | UInt64 | KiloBytes bulk copied. |
| Caption | | String | A short textual description (one-line string) for the statistic or metric. |
| DataFilesSizeKB | | UInt64 | The cumulative size of all the data files in the database. |
| DBCCLogicalScanBytesPersec | | UInt64 | Logical read scan rate for DBCC commands |
| Description | | String | A textual description of the statistic or metric. |
| Frequency_Object | | UInt64 | NA |
| Frequency_PerfTime | | UInt64 | NA |
| Frequency_Sys100NS | | UInt64 | NA |
| LogBytesFlushedPersec | | UInt64 | Total number of log bytes flushed. |
| LogCacheHitRatio | | UInt64 | Percentage of log cache reads that were satisfied from the log cache. |
| LogCacheHitRatio_Base | | UInt64 | Base for log cache calculations |
| LogCacheReadsPersec | | UInt64 | Reads performed through the log manager cache. |
| LogFilesSizeKB | | UInt64 | The cumulative size of all the log files in the database. |
| LogFilesUsedSizeKB | | UInt64 | The cumulative used size of all the log files in the database. |
| LogFlushesPersec | | UInt64 | Number of log flushes. |
| LogFlushWaitsPersec | | UInt64 | Number of commits waiting on log flush. |
| LogFlushWaitTime | | UInt64 | Total wait time (milliseconds). |
| LogGrowths | | UInt64 | Total number of log growths for this database. |
| LogShrinks | | UInt64 | Total number of log shrinks for this database. |
| LogTruncations | | UInt64 | Total number of log truncations for this database. |
| Name | | String | 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. |
| PercentLogUsed | | UInt64 | The percent of space in the log that is in use. |
| ReplPendingXacts | | UInt64 | Number of pending replication transactions in the database. |
| ReplTransRate | | UInt64 | Replication transaction rate (replicated transactions/sec.). |
| ShrinkDataMovementBytesPersec | | UInt64 | The rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE. |
| Timestamp_Object | | UInt64 | NA |
| Timestamp_PerfTime | | UInt64 | NA |
| Timestamp_Sys100NS | | UInt64 | NA |
| TransactionsPersec | | UInt64 | Number of transactions started for the database. |
| SAMPLE DATA INSTANCE |
Class does not currently contain data instances
|
