question

jason_clark03 avatar image
jason_clark03 asked

Why is SQL Server consuming more than the max memory allowed?

SQL is consuming more memory, min memory is 0, max server memory is 8 gb. Current SQL consumption is 8.8 GB. Total available RAM is 12 GB. Please help me investigate and solve this.
sql-server-2008memory-utilization
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
From https://technet.microsoft.com/en-us/library/ms180797(v=sql.105).aspx > The min server memory and max server memory configuration options establish upper and lower limits to the amount of memory used by the buffer pool of the Microsoft SQL Server Database Engine and > SQL Server as a process acquires more memory than specified by max server memory option. Both internal and external components can allocate memory outside of the buffer pool, which consumes additional memory, but the memory allocated to the buffer pool usually represents the largest portion of memory consumed by SQL Server.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.