MS SQL Server Perfmon Memory Manager (MSSQL_SERVER_PERFMON_MEMORY_MANAGER)

The MSSQL_SERVER_PERFMON_MEMORY_MANAGER application class provides counters to monitor overall server memory usage. Monitoring overall server memory usage to gauge user activity and resource usage can help you to identify performance bottlenecks. Monitoring the memory used by an instance of SQL Server can help determine:

• If bottlenecks exist from inadequate physical memory for storing frequently accessed data in cache. If memory is inadequate, SQL Server must retrieve the data from disk.

• If query performance can be improved by adding more memory or by making more memory available to the data cache or SQL Server internal structures.

Application class attributes

Attributes (parameters)

• Connection Memory (KB) (ConnectionMemoryKB)
• Database Cache Memory (KB) (DatabaseCacheMemoryKB)
• External benefit of memory (ExternalBenefitOfMemory)
• Free Memory (KB) (FreeMemoryKB)
• Free Memory (MB) (FreeMemoryMB)
• Granted Workspace Memory (KB) (GrantedWorkspaceMemoryKB)
• Lock Blocks (LockBlocks)
• Lock Blocks Allocated (LockBlocksAllocated)
• Lock Memory (KB) (LockMemoryKB)
• Lock Owner Blocks (LockOwnerBlocks)
• Lock Owner Blocks Allocated (LockOwnerBlocksAllocated)
• Log Pool Memory (KB) (LogPoolMemoryKB)
• Maximum Workspace Memory (KB) (MaximumWorkspaceMemoryKB)
• Maximum Workspace Memory (MB) (MaximumWorkspaceMemoryMB)
• Memory Grants Outstanding (MemoryGrantsOutstanding)
• Memory Grants Pending (MemoryGrantsPending)
• Optimizer Memory (KB) (OptimizerMemoryKB)
• Reserved Server Memory (KB) (ReservedServerMemoryKB)
• SQL Cache Memory (KB) (SQLCacheMemoryKB)
• Stolen Server Memory (KB) (StolenServerMemoryKB)
• Target Server Memory (KB) (TargetServerMemoryKB)
• Target Server Memory (MB) (TargetServerMemoryMB)
• Total Server Memory (KB) (TotalServerMemoryKB)
• Total Server Memory (MB) (TotalServerMemoryMB)