Sunday, February 19, 2012

Committed Memory

I recently did some performance testing and one of the
counters I monitored was Committed memory. Can someone
explain what this means. Is it the amount SQL Server can
access?
Also when AWE is enabled the memory used in Task manager
goes to whatever the limit is for SQL Server. Is that
because it is reserved for SQL Server processes.
Thanks for any advice.
JamieWhen you use AWE memory with SQL Server, SQL statically maps all of the
memory at startup (unlike nonAWE memory which is dynamic). If you want to
reserve less memory for SQL and leave more memory for other apps, use the
"sp_configure max server memory" option. Books on Line has a good
description under "Managing AWE Memory".
Brian Goldstein
SQL Server Product Group
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Jamie Downs" <jamie@.and.co.uk> wrote in message
news:09b801c33fb5$93e73720$a101280a@.phx.gbl...
> I recently did some performance testing and one of the
> counters I monitored was Committed memory. Can someone
> explain what this means. Is it the amount SQL Server can
> access?
> Also when AWE is enabled the memory used in Task manager
> goes to whatever the limit is for SQL Server. Is that
> because it is reserved for SQL Server processes.
> Thanks for any advice.
> Jamie

No comments:

Post a Comment