Limit Memory Usage on Microsoft Small Business Server 2008 / 2011

[Adventech]

PROBLEM:
How to Limit Memory Usage from Exchange and SQL on Microsoft Small Business Server 2008 / 2011?
How to limit Exchange 2010 memory usage?
How to limit SQL Server 2005/2008 memory usage?

SOLUTION:

EXCHANGE SERVER (Part 1)
1.)Open ADSIedit by navigating to Start > All Programs > Administrative Tools > ADSI Edit.
2.) Right click the root of the tree and select "Connect To"
3.) Under "Connection Point" > Select a well known Naming Context > Select, "Configuration"



4.) Click OK.
5.) Once connected to the Configuration Naming Context, navigate to the following item:

Configuration -> Services -> Microsoft Exchange -> "Organization Name" -> Administrative Groups > "Administrative Group" -> Servers -> "Server Name" -> InformationStore

6.) Right click Information Store and choose properties.
7.) Scroll down to msExchESEParamCacheSizeMin attribute and set the value according to your requirements.
8.) Scroll down to msExchESEParamCacheSizeMax attribute and set the value according to your requirements.



9.) Restart Exchange Information Store Service.

NOTE: Exchange 2007 works with 8kB pages and Exchange 2010 works with 32kB pages.
So if you want to limit the size of memory used to 4GB, you will need the following calculations:

Exchange 2007: 4 GB = 4.194.304 KB / 8 KB => 524288
Exchange 2010: 4 GB = 4.194.304 KB / 32 KB => 131072


EXAMPLES:

Exchange 2010:
Min – 1GB: msExchESEParamCacheSizeMin = 32768
Max – 4GB: msExchESEParamCacheSizeMax = 131072

other - 512MB: = 16384

Exchange 2007:
Min – 1GB: msExchESEParamCacheSizeMin = 131072
Max – 4GB: msExchESEParamCacheSizeMax = 524288

other - 512MB = 65536


SQL SERVER (Part 2)
1.) Open "SQL Server Management Studio". Note: Right Click and Run-as Administrator.
2.) Login to the following instances.

• <SERVERNAME>\SBSMONITORING
• <SERVERNAME>\SHAREPOINT
• <SERVERNAME>\MICROSOFT##SSEE

Note: In order to log in to "MICROSOFT##SSEE" you have to use the following as the "Server Name".

Code Select Expand

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

3.) Right click on the root and choose properties.
4.) Under "Memory" change the Maximum Server Memory to desired amount.
5.) Restart SQL services.