| Win32_PerfFormattedData_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 | |||
| [Description("This defines memory usage."): ToInstance Amended, DisplayName("SQLServer:Memory Manager"): ToInstance Amended, genericperfctr: ToInstance Amended, locale(1033): ToInstance Amended] instance of Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryManager { [Description("Total amount of dynamic memory the server is using for maintaining connections"): ToInstance Amended, DisplayName("Connection Memory (KB)"): ToInstance Amended] ConnectionMemoryKB = "0"; [Description("Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations."): ToInstance Amended, DisplayName("Granted Workspace Memory (KB)"): ToInstance Amended] GrantedWorkspaceMemoryKB = "0"; [Description("The current number of lock blocks that are in use on the server. Refreshed periodically."): ToInstance Amended, DisplayName("Lock Blocks"): ToInstance Amended] LockBlocks = "0"; [Description("The current number of allocated lock blocks."): ToInstance Amended, DisplayName("Lock Blocks Allocated"): ToInstance Amended] LockBlocksAllocated = "0"; [Description("Total amount of dynamic memory the server is using for locks"): ToInstance Amended, DisplayName("Lock Memory (KB)"): ToInstance Amended] LockMemoryKB = "0"; [Description("The number of lock owner blocks that are currently in use on the server. Refreshed periodically."): ToInstance Amended, DisplayName("Lock Owner Blocks"): ToInstance Amended] LockOwnerBlocks = "0"; [Description("The current number of allocated lock owner blocks."): ToInstance Amended, DisplayName("Lock Owner Blocks Allocated"): ToInstance Amended] LockOwnerBlocksAllocated = "0"; [Description("Total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations."): ToInstance Amended, DisplayName("Maximum Workspace Memory (KB)"): ToInstance Amended] MaximumWorkspaceMemoryKB = "0"; [Description("Current number of processes that have successfully acquired a workspace memory grant"): ToInstance Amended, DisplayName("Memory Grants Outstanding"): ToInstance Amended] MemoryGrantsOutstanding = "0"; [Description("Current number of processes waiting for a workspace memory grant"): ToInstance Amended, DisplayName("Memory Grants Pending"): ToInstance Amended] MemoryGrantsPending = "0"; [Description("Total amount of dynamic memory the server is using for query optimization"): ToInstance Amended, DisplayName("Optimizer Memory (KB)"): ToInstance Amended] OptimizerMemoryKB = "0"; [Description("Total amount of dynamic memory the server is using for the dynamic SQL cache"): ToInstance Amended, DisplayName("SQL Cache Memory (KB)"): ToInstance Amended] SQLCacheMemoryKB = "0"; [Description("Total amount of dynamic memory the server is willing to consume"): ToInstance Amended, DisplayName("Target Server Memory (KB)"): ToInstance Amended] TargetServerMemoryKB = "0"; [Description("Total amount of dynamic memory the server is currently consuming"): ToInstance Amended, DisplayName("Total Server Memory (KB)"): ToInstance Amended] TotalServerMemoryKB = "0"; }; | |||