[dba-SQLServer] Limit SQL Server total CPU memory

jwcolby jwcolby at colbyconsulting.com
Wed Nov 3 18:57:43 CDT 2010


OK, I did pare back the memory to 24 gigs and now the same query only uses 90% of the memory.  Of 
course it is back to back runs so it may already have cached some stuff.

John W. Colby
www.ColbyConsulting.com

On 11/3/2010 7:02 PM, jwcolby wrote:
> My SQL Server machine currently has 32 gigs of RAM and 8 processors.  In the properties for the
> server, memory tab, I am telling SQL Server that it can have 26 gigs and 6 processors.  I am
> currently running a microsoft VM on that server which needs 3 gigs and one processor, and I also
> want to leave the OS itself some memory (let's say 3 gigs).
>
> When I run a complex query I get physical memory usage climbing to 30.9 gigs (96%).  I am wondering
> if I need to drop the memory assigned to SQL Server.
>



More information about the dba-SQLServer mailing list