[dba-SQLServer] SQL Server - how much memory to assign

jwcolby jwcolby at colbyconsulting.com
Mon Jun 29 08:58:54 CDT 2009


I now have two servers, one dedicated to SQL Server and the other to VMs.  The SQL Server has 16 
gigs and I am wondering how much to assign to SQL Server in its memory configuration and how much to 
leave for the OS.  It will be running a couple of apps such as Access and Ultra Edit, Excel 
occasionally, but nothing too memory intensive.  I am figuring something like 14 gigs for SQL Server 
and 2 gigs for the OS apps.

-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list