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

I might go a little lower on SQL Server, monitor it and then raise it if all is okay.  Maybe 12 for SQL, 4 for everything else then monitor for a while and see how it goes.  Spotlight on Windows (freeware) is a nice little monitoring tool, that will show you what is using how much, etc.

Nancy Lytle 










 EMAILING FOR THE GREATER GOOD
Join me
 
> Date: Mon, 29 Jun 2009 09:58:54 -0400
> From: jwcolby at colbyconsulting.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] SQL Server - how much memory to assign
> 
> 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
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>