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

\\.\pipe\mssql$microsoft##SSEE\sql\query

as pointed out in the screencast.

SBS 2008 Unleashed

Image of Windows Small Business Server 2008 Unleashed

SBS 2003 Unleashed

Image of Microsoft Small Business Server 2003 Unleashed

Partners