Memory allocations for SQL and other server processes

Tags:
SQL Server memory
If I am correct, available bytes is the amount of memory available to the SQL Server at that point in time, working set is the amount SQL is actually using and total server memory is the total amount of all memory processes on that server. I have on a 4GB box with 3GB fixed and set aside for SQL: 1.46GB of available bites, 1.65 for working set, and 1.58 of total server memory How is SQL using more memory than all the other processes and itself combined? Where did I go wrong?

Answer Wiki

Thanks. We'll let you know when a new response is added.

According to Perform:

Working Set:
Working Set is the current size, in bytes, of the Working Set of this process. The Working Set is the set of memory pages touched recently by the threads in the process. If free memory in the computer is above a threshold, pages are left in the Working Set of a process even if they are not in use. When free memory falls below a threshold, pages are trimmed from Working Sets. If they are needed they will then be soft-faulted back into the Working Set before leaving main memory.

Total Server Memory:
Total amount of dynamic memory the server is currently consuming

Keep in mind that Total Server Memory is a SQL Server counter (SQLServer:Memory Manager performance object), while working set is a system counter (Process performance object). So one is being measured from within the database while the other from outside the database. Also the counters could have been taken at different moments in time, or averaged differently which would give you a strange looking number.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following