SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,995 questions
anyone has the idea ?
DBCC memory : Current commited vs Page free vs Page allocated vs pages in uses
![](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)
sakuraime
2,321
Reputation points
Current commited vs Page free vs Page allocated vs pages in uses~~~~ <<< What are their relationship
4 answers
Sort by: Most helpful
-
-
sakuraime 2,321 Reputation points
2020-08-30T09:45:44.63+00:00 anyone has the idea ?
-
![](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(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT 6,611 Reputation points2020-08-31T09:38:11.077+00:00 Hi,
Starting from SQL Server 2012, most of the information related to the memory manager in the DBCC MemoryStatus output has been moved from the Buffer Pool to the memory manager. The "Pages In Use" is a new counter.
You can refer to the Memory Manager surface area changes in SQL Server 2012 .This shows their definition, but not the "relationship".
-
Shashank Singh 6,246 Reputation points2020-08-31T09:57:34.717+00:00 Hi,
This has already been answered in old MSDN site or not ?
dbcc-memory-status-current-commited
For DBCC memoryoutput and explanation please refer
how-to-use-the-dbcc-memorystatus-command-to-monitor-memory-usage-on-sq