Hi @Alen Cappelletti ,
I think your question is that the number in windows performance counter is not euqal to the number you got by T-SQL. If I misunderstood your problem pls kindly let me know. And I think the point of this problem is the WORKING SET. A Working Set is considered as physical memory that a process can use (but does not necessarily use), which means the memory that can be accessed without causing a page fault exception. A Working Set contains memory that may be shared by other programs. A DLL, for example, is a typical resource that may be shared by other programs. So the Working Set of all processes may add up to more than the actual physical memory.
"sqlservr.exe" and "commited page"... do I have to think of them as separate numbers?
I'm sorry that I don't understand this question very well. But in my opinion I don't think that they are separated cuz I can use the T-SQL to check the number of current committed:
I hope this answer can be useful.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"