Susan Bradley has touched on this subject before over various posts on her blog, but I wanted to give a summary of how, on our recent “up to date” installations, we are tuning memory on our SBS Servers.
Our servers are normally around the following specification and configuration:
Dual Xeon or Single Quad Core processors
4GB of RAM
RAID 1 or RAID 5 configuration
Windows Small Business Server 2003 R2
Windows 2003 SP2, and all hotfixes.
Windows Server Update Services 3
Sharepoint Services 3
All hotifixes and patches installed.
Normally Running GFI MailEssentials and MailSecurity
This means that we have the following databases running:
Windows Internal Database (Sharepoint 3 / WSUS 3)
MSFW (on ISA Premium installs only)
Basically, all you need to do is run the commands listed on Susan’s post here on each database and tune as required. What has worked for me is to set the following limits on the above specification.
Windows Internal Database – 256MB RAM
Sharepoint 2 Database – 75MB RAM
SBS Monitoring Database – 50MB RAM
MSFW Database – 75MB RAM
Doing this, on your average 30 user site has had no ill effect. You may also notice that I have GFI running on these servers in normal circumstances. I normally setup a separate instance for the GFI stuff, and limit that database to 100MB.
Hopefully this will help some of you out there that happen to be running the same kind of specification installs for your clients.