![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,670 questions
what's the difference between pages_kb and virtual_memory_committed_kb ?
I guess you are referring to sys.dm_os_memory_clerks
Pages_kb is amount of page memory allocated. You can simply called it as memory allocated for working set.
Virtual_memory_committed_kb is Amount of virtual memory committed. A committed memory is backed by physical memory. This is committed virtual memory as tracked by this clerk. VM committed in simple terms some part of memory which was reserved and committed but now in page file or swapped back to disk behaving as virtual memory
BTW the query you are using is incorrect, there is no need to sum all the columns.