| Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager |
| This defines memory usage. |
| NameSpace Path |
| \ROOT\CIMV2 |
| PROPERTY | SMS_REPORT | CIMTYPE | DESCRIPTION |
| Caption | | String | A short textual description (one-line string) for the statistic or metric. |
| ConnectionMemoryKB | | UInt64 | Total amount of dynamic memory the server is using for maintaining connections |
| Description | | String | A textual description of the statistic or metric. |
| Frequency_Object | | UInt64 | NA |
| Frequency_PerfTime | | UInt64 | NA |
| Frequency_Sys100NS | | UInt64 | NA |
| GrantedWorkspaceMemoryKB | | UInt64 | Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations. |
| LockBlocks | | UInt64 | The current number of lock blocks that are in use on the server. Refreshed periodically. |
| LockBlocksAllocated | | UInt64 | The current number of allocated lock blocks. |
| LockMemoryKB | | UInt64 | Total amount of dynamic memory the server is using for locks |
| LockOwnerBlocks | | UInt64 | The number of lock owner blocks that are currently in use on the server. Refreshed periodically. |
| LockOwnerBlocksAllocated | | UInt64 | The current number of allocated lock owner blocks. |
| MaximumWorkspaceMemoryKB | | UInt64 | Total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations. |
| MemoryGrantsOutstanding | | UInt64 | Current number of processes that have successfully acquired a workspace memory grant |
| MemoryGrantsPending | | UInt64 | Current number of processes waiting for a workspace memory grant |
| 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. |
| OptimizerMemoryKB | | UInt64 | Total amount of dynamic memory the server is using for query optimization |
| SQLCacheMemoryKB | | UInt64 | Total amount of dynamic memory the server is using for the dynamic SQL cache |
| TargetServerMemoryKB | | UInt64 | Total amount of dynamic memory the server is willing to consume |
| Timestamp_Object | | UInt64 | NA |
| Timestamp_PerfTime | | UInt64 | NA |
| Timestamp_Sys100NS | | UInt64 | NA |
| TotalServerMemoryKB | | UInt64 | Total amount of dynamic memory the server is currently consuming |
| SAMPLE DATA INSTANCE |
Class does not currently contain data instances
|
