Limit Sharepoint Database Memory Usage


The WSS Companyweb database on SBS 2008 servers can use a large allocation of RAM on the server, similar to the SBSMonitoring database. This screencast shows how to limit the maximum RAM used by the Sharepoint database on an SBS 2008 server. The one significant difference in this process as opposed to limiting the RAM on the SBSMonitoring database is the actual database name. The path to the Sharepoint database is

.pipemssql$microsoft##SSEEsqlquery

as pointed out in the screencast.